MySQL Forums
Forum List  »  French

Re: deux resultats dans une seul tableau
Posted by: Benoit St-Jean
Date: October 22, 2008 03:43PM

Par exemple:

SELECT prenom, 'homme' as sexe
FROM table_personnes
WHERE gender = 'M'

UNION ALL

SELECT prenom, 'femme' as sexe
FROM table_personnes
WHERE gender = 'F'

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: deux resultats dans une seul tableau
2910
October 22, 2008 03:43PM


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.