Left joins are only supported in Oracle10i and higher. The early version use (+) for joins. So in your case SELECT a.abmonth, a.ablist, c.curr_stat, c.changes, c.link FROM tblablist a,tblcomments c Where c.esnum(+) = a.esnum and a.esnum = '8099'
-----Original Message----- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: March 18, 2004 12:03 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] SQL Error ???? Can anybody see any problems with the select statement below. I'm getting the following error when trying to run this statement against an Oracle Table. I'm using .asp. I've used a similar select statement on other pages and it works fine. Err: ORA-00933: SQL command not properly ended strSql_ab = "SELECT a.abmonth, a.ablist, c.curr_stat, c.changes, c.link FROM tblablist a LEFT JOIN tblcomments c ON (c.esnum = a.esnum) where a.esnum = '8099'" Thanks in advance Robert ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ____ * The WDVL Discussion List from WDVL.COM * ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.