SELECT DISTINCT id-script FROM YOURTABLE where id_language = 'SELECTED LANGUAGE' ;
no ?
Justin Patrin wrote:
Christine Clerc wrote:
Hi,
I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text is written in) etc.
So two texts may have the same id_script but with different id_language.
I need to retrieve the list (without duplicate) of id-script that are described in one language and NOT in another.
Is there hope ? Any help would be welcome.
Chris
Maybe give us a sample of the SQL you wish to use? You can probably get it done without a sub-select.
That being said, the newest versions of MySQL support sub-selects, but you'd have to use an unstable version.
-- Alban Médici R&D software engineer ------------------------------ you can contact me @ : [EMAIL PROTECTED] http://www.netcentrex.net ------------------------------
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
