It seems as if Oracle 9+ now supports joins but 8i didn't. No wonder Oracle programmers make so much. Love the proprietary stuff. I'm sure Rudy knew this one off the top of his head...
-----Original Message----- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 11:14 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: SQL Error ???? Very interesting. That worked. Thanks for the help. Robert *---------------------* Application Programmer x4863 -----Original Message----- From: Linden, Todd [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 11:08 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: SQL Error ???? Whoa! I found this on a news group about Oracle... "In Oracle 8 there are no JOIN statements. Use "(+)" operator in WHERE clause." -----Original Message----- From: Hoenig, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 11:03 AM 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.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. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ______________________________________________________________________ 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.