Re: What is wrong with my simple SQL syntax?

Thanks all for your help.

I actually have "Elmasri and Navathe - Fundamentals of Database Systems" on my bookshelf, so I'll just start reading :o)

/Kenneth

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3AF8D55F.954794A9_at_exesolutions.com...
> Kenneth Jensen wrote:
>
> > I try to make a simple SQL syntax the way I have always done on other
> > databases, but Oracle says that it hasn't been properly terminated.
> >
> > SELECT tblHippie.*, tblTrip.strName FROM
> > tblHippie INNER JOIN tblTrip ON tblHippie.lngHippieID =
 tblTrip.lngHippieID
> >
> > Can someone please tell me, what's wrong with it?
> >
> > Yours sincerely
> > Kenneth Jensen
>
> What is wrong is that you never opened a book on PL/SQL.
>
> You can not work with Oracle using syntax that appears to be straight out
 of
> SQL Server.
>
> The advise you have already received from TurkBear will get you through
 this
> one. But you will get no further if you don't buy a PL/SQL book, open it,
 and
> read it.
>
> Daniel A. Morgan
>
Received on Wed May 09 2001 - 04:44:30 CDT