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 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.id = table3.id > WHERE table1.status = 'open'"; > > > Q: Is something like this possible? > > > > Thanks, > c...@hosting4days.com > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=fuller.art...@gmail.com > >
