From: Johan De Meersman
Date: April 28 2011 1:41pm
Subject: Re: left join two tables
List-Archive: http://lists.mysql.com/mysql/224903
Message-Id: <4c10b8dd-7065-495e-90ef-c41807536485@zimbra>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_e4b615d0-29c8-489e-ad74-d4700f691db1"

--=_e4b615d0-29c8-489e-ad74-d4700f691db1
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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 

--=_e4b615d0-29c8-489e-ad74-d4700f691db1--