Results 1 to 2 of 2

Thread: Outer join in Oracle

  1. Jun 22nd, 2000, 04:04 AM #1
    MPardo
    MPardo is offline

    Thread Starter
    Member
    Join Date
    Jan 1999
    Location
    Warner Robins, GA
    Posts
    37
    Hi,

    I need a SQL statement that does an outer join. I know how to do it in Access/SQL Server but need to do it in Oracle as well.

    I want to return all the records from one table that match some criteria and any records from another table. The only join I know how to do in Oracle is an "inner" join but this of course doesn't give me all the data I need. Thanks for any help and let me know if more information is required.

    Matt
    Reply With Quote Reply With Quote
  2. Jun 22nd, 2000, 04:08 AM #2
    MPardo
    MPardo is offline

    Thread Starter
    Member
    Join Date
    Jan 1999
    Location
    Warner Robins, GA
    Posts
    37
    Nevermind, I found another post that showed you put a "(+)" after it.

    Matt
    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