Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 25th, 2003, 11:45 AM
Authorized User
 
Join Date: Jun 2003
Location: , , .
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
  #2 (permalink)  
Old June 29th, 2003, 07:55 PM
Registered User
 
Join Date: Jun 2003
Location: , , .
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
  #3 (permalink)  
Old October 27th, 2003, 09:23 PM
Authorized User
 
Join Date: Aug 2003
Location: , , Malaysia.
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 (+)

 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 09:07 PM.


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