MySQL Forums
Forum List  »  French

Re: Jointures
Posted by: Nicola T
Date: January 24, 2009 12:00PM

Bonjour Jean,

Merci de votre réponse.

Je viens d'essayer le LEFT OUTER JOIN, toujours le même résultat :

select participation.ID_RANDONNEE, participation.BOUCLE_PARTICIPATION, count(*)
from `participation`
left outer join `randonneur`
using(`ID_RANDONNEUR`)
where `randonneur`.`SEXE_RANDONNEUR`='Femme'
group by `participation`.`ID_RANDONNEE`, `participation`.`BOUCLE_PARTICIPATION`;

Résultat : toujours le même.

Le soucis étant qu'il faudrait que MySQL fasse figurer les types ENUM du champ `participation`.`BOUCLE_PARTICIPATION` qui n'ont pas d'occurrence dans cette table.

Encore merci.

Nico.

Options: ReplyQuote


Subject
Views
Written By
Posted
6645
January 24, 2009 11:24AM
3361
January 24, 2009 11:54AM
Re: Jointures
3287
January 24, 2009 12:00PM
3251
January 24, 2009 02:19PM
3361
January 25, 2009 03:19AM
3216
January 25, 2009 07:55AM


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.