List:General Discussion« Previous MessageNext 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 tablesRocio Gomez Escribano28 Apr
  • Re: left join two tablesJohan De Meersman28 Apr
    • Re: left join two tablesDarryle Steplight28 Apr