Results 1 to 10 of 197

Thread: IT Professionals

Threaded View

  1. #11
    Senior Member Platinum Hubber
    Join Date
    Oct 2004
    Posts
    10,586
    Post Thanks / Like
    There are only two tables. So, if you place the field of contact table on the left hand side of your query, then it should be left outer join.

    i.e. say, if you join as
    contact.emplid = course.emplid, then it has to be contact.emplid (+) = course.emplid, in Oralce.

    In generic SQL, it can be written as :

    select * from contact
    left outer join course on
    contact.emplid = course.emplid

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

Similar Threads

  1. IT Professionals
    By Raghu in forum Miscellaneous Topics
    Replies: 206
    Last Post: 19th July 2007, 09:09 AM

Bookmarks

Posting Permissions

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