MySQL Forums
Forum List  »  Italian

Advanced Search
New Topic

Re: Problema query left join annidata e su più tabelle
Posted by: Cristian Pinto
Date: April 20, 2015 03:22PM

Mi sono risposto da solo riprovando e riprovando ecco la soluzione:

SELECT *, CONCAT(vetture.modello,' ',vetture.versione,' ',CAST(vetture.anno AS CHAR)) AS vettura FROM tblVettureLampadine AS vetture LEFT JOIN tblLampadine AS lampadine ON vetture.id=lampadine.vettura, tblMarcheAuto AS marche WHERE marche.id=vetture.marca AND vetture.marca=12 ORDER BY vetture.modello, vetture.anno

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Problema query left join annidata e su più tabelle
1795
Cristian Pinto
April 20, 2015 05:47AM
Re: Problema query left join annidata e su più tabelle
876
Cristian Pinto
April 20, 2015 03:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.