MySQL Lists: mysql: left join two tables

List:	General Discussion	« Previous Message Next Message »
From:	Rocio Gomez Escribano	Date:	April 28 2011 1:21pm
Subject:	left join two tables
View as plain text

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

 

Thanks!!!

 

Rocío Gómez Escribano

 <mailto:r.sanchez@stripped> r.gomez@stripped

 

Descripción: cid:image002.jpg@stripped

Polígono Campollano C/F, nº21T

02007 Albacete (España)

Tlf:967-504-513  Fax: 967-504-513

www.ingenia-soluciones.com

 


Attachment: [text/html]

Attachment: [text/html]

Attachment: [text/html]

Thread
• left join two tables	Rocio Gomez Escribano	28 Apr
• Re: left join two tables	Johan De Meersman	28 Apr
• Re: left join two tables	Darryle Steplight	28 Apr