Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 25th, 2003, 11:45 AM
Authorized User
 
Join Date: Jun 2003
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default LEFT JOIN syntax

Hello-

I'm used to using MSSQL, but I'm now working on an Oracle system. I need to use a Left outter join for a query I'm writting, but I am getting a syntax error that I don't know how to fix. Please let me know if you see a blatant problem with this FROM clause.

FROM rss_user LEFT JOIN ent_user ON rss_user.user_id = ent_user.user_id

I get a "ORA-00933: SQL command not properly ended" error on the word JOIN.

Thanks in advance,
Mike
 
Old June 29th, 2003, 07:55 PM
Registered User
 
Join Date: Jun 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mike-
It looks like we're both in the same boat. I've spent all weekend learning about Oracle and had the exact same question as I am trying to port code form SQL Server 2K to Oracle 8i/9i.
Instead of defining the join in the FROM clause, you comma delimit the tables and join them in the where clause to get a left join I think it looks like this (I'm new)
WHERE table1.field (+) = table2.field
You might need to move the (+).
HTH
 
Old October 27th, 2003, 09:23 PM
Authorized User
 
Join Date: Aug 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes, you can use some thing like this
field_name1 (+) = field_name2 or
field_name1 = field_name2 (+)






Similar Threads
Thread Thread Starter Forum Replies Last Post
left outer join keyvanjan Classic ASP Basics 1 April 15th, 2006 05:37 AM
Why doesn't this LEFT JOIN work? harg7769 Access 2 April 13th, 2005 04:49 AM
left join msrnivas Classic ASP Databases 2 October 15th, 2004 07:37 AM
Oracle 8i inner join and left join problem puteri_84 Oracle 2 August 19th, 2004 07:14 AM
Left Join error mariakovacs Access ASP 2 October 13th, 2003 04:16 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.