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, cool@stripped <
cool@stripped> 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,
> cool@stripped
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
