Joining 3 Tables

Results 1 to 3 of 3

Thread: Joining 3 Tables

  1. #1
    Dan Reynolds Guest

    Default Joining 3 Tables

    How do you join 3 tables using SQL. For example:<BR><BR>I have the select statement:<BR>Select * from Table1 LEFT JOIN Table2 ON Table1.ID=Table2.ID<BR><BR>How can I also join Table3 on Table3.ID?

  2. #2
    Join Date
    Dec 1969

    Default Round about way...

    Streight SQL...<BR><BR>select table1.*, table2.*, table3.* from table1, table2, table3 where = and =<BR><BR>or something similar.<BR><BR>-- Whol

  3. #3
    Bill H. Guest

    Default Same way

    Select * from Table1 LEFT JOIN Table2 ON Table1.ID=Table2.ID<BR>LEFT Join Table3 ON Table1.ID=Table3.ID<BR><BR><BR> <BR>

Posting Permissions

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