MySQL Forums
Forum List  »  Italian

Re: Aiuto per favore!!
Posted by: andrea bearzi
Date: April 08, 2007 04:39AM

Eureka son riuscito a farla funzionare ho inglobato dentro la condizione della left join la clausola che prima tenevo dentro al where!!! :) :)

non so se e' sql standard ma funziona e per ora uso sta cosa!!


Query non funzionante che non riporta i null:
SELECT * FROM classi c
left join corsi_classi cc ON c.cls_cod=cc.cls_cod
where cc.crs_cod=249



Qury che funziona:
SELECT * FROM classi c
left join corsi_classi cc ON
(c.cls_cod=cc.cls_cod AND cc.crs_cod=249)


Ciauz

Options: ReplyQuote


Subject
Views
Written By
Posted
4076
February 04, 2007 03:47AM
3182
April 08, 2007 04:34AM
Re: Aiuto per favore!!
3026
April 08, 2007 04:39AM


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.