Re: Is It Possible to create a Join with Multiple Tables

2009-09-29 Thread Shawn Green
c...@hosting4days.com wrote: :Newbie: Short Question: Is it possible to create an inner join (or another join) with multiple tables? something like $query_list1 = "SELECT table1.id,table1.status, table2.id, table3.id (more here - etc.) FROM table1 INNER JOIN table2 ON table1.id = table2.id

Re: Is It Possible to create a Join with Multiple Tables

2009-09-26 Thread Arthur Fuller
I don't see why not, but another choice is to create a view that encompasses all these tables and Select * From my_view. Arthur On Fri, Sep 25, 2009 at 11:28 PM, c...@hosting4days.com < c...@hosting4days.com> wrote: > :Newbie: > Short Question: Is it possible to create an inner join (or another j

Is It Possible to create a Join with Multiple Tables

2009-09-25 Thread c...@hosting4days.com
:Newbie: Short Question: Is it possible to create an inner join (or another join) with multiple tables? something like $query_list1 = "SELECT table1.id,table1.status, table2.id, table3.id (more here - etc.) FROM table1 INNER JOIN table2 ON table1.id = table2.id INNER JOIN table3 ON table2.