Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up Unanswered: Join with three tables

    Is it possible to join three tables in a single query based on multiple conditions which involve all the three tables..?
    If possible could anyone just give the syntax for it..

    Thnks in advance....
    Sudar

    --
    My Blog

  2. #2
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up Found the solution

    I found the solution by myself..

    The syntax is

    Select col_names from table1 left join table2 on join_cond left join table3 on join_cond

    Thnks any ways
    Sudar

    --
    My Blog

Posting Permissions

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