List:General Discussion« Previous MessageNext Message »
From:Arthur Fuller Date:September 26 2009 1:40pm
Subject:Re: Is It Possible to create a Join with Multiple Tables
View as plain text  
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
>
>

Thread
Is It Possible to create a Join with Multiple Tablescool@hosting4days.com26 Sep
  • Re: Is It Possible to create a Join with Multiple TablesArthur Fuller26 Sep
  • Re: Is It Possible to create a Join with Multiple TablesShawn Green29 Sep