List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:April 28 2011 1:41pm
Subject:Re: left join two tables
View as plain text  
Hey there, 

----- Original Message -----

> From: "Rocio Gomez Escribano" <r.gomez@stripped>

> Hi!! Is it possible to create a left join consult with 2 tables??

> I mean:

> SELECT * FROM table1 LEFT JOIN (table2, table3) on table1.ID =
> table2.subID and table1.ID= table3.subID
Pretty close already. Might I suggest sampling the fine manual ? 

Have a look at http://dev.mysql.com/doc/refman/5.0/en/join.html 

-- 
Bier met grenadyn 
Is als mosterd by den wyn 
Sy die't drinkt, is eene kwezel 
Hy die't drinkt, is ras een ezel 

Thread
left join two tablesRocio Gomez Escribano28 Apr
  • Re: left join two tablesJohan De Meersman28 Apr
    • Re: left join two tablesDarryle Steplight28 Apr