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
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
: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.