List:General Discussion« Previous MessageNext Message »
From:cool@hosting4days.com Date:September 26 2009 3:28am
Subject:Is It Possible to create a Join with Multiple Tables
View as plain text  
: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





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