Re: What is wrong with my simple SQL syntax?

Oracle's SQL would be:

SELECT tblHippie.*, tblTrip.strName FROM tblHippie,tblTrip
where
 tblHippie.lngHippieID = tblTrip.lngHippieID;

"Kenneth Jensen" <kennethj_at_mailme.dk> 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
>
Received on Tue May 08 2001 - 12:29:21 CDT