Results 1 to 2 of 2

Thread: Oracle Equivalent of SQL Server Left Join

  1. Sep 12th, 2001, 08:59 AM #1
    PunkRockNeil
    PunkRockNeil is offline

    Thread Starter
    Lively Member
    Join Date
    May 2001
    Location
    Fredericton, NB, Canada
    Posts
    85

    Oracle Equivalent of SQL Server Left Join

    I was wondering if anyone knew the Oracle equivalent of the Left Join in SQL Server.

    Thanks,
    Neil Fairweather
    Reply With Quote Reply With Quote
  2. Sep 12th, 2001, 09:07 AM #2
    Bonker Gudd
    Bonker Gudd is offline
    Fanatic Member Bonker Gudd's Avatar
    Join Date
    Mar 2000
    Location
    Saturn
    Posts
    748
    You put (+) on all instances of the optional table in the where clause, e.g:

    SELECT a.x, b.y FROM a, b WHERE a.z = (+) b.z AND b.w (+) = 1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width