Re: Re: Subselect ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Well, I had tried this :
SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin;
But then I have to do this with the selection :
SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget;
but it cannot work since I get back the id_script from the first selection !

See a sample of the table :

id_readme, id_script, id-language
1, 2, 4
2, 3, 1
3, 3, 4
4, 4, 4

All the scripts are in english, but one has been already translated into French.

I want to say to the translator that works from english to french,
1) you have script 2 and 4 to translate
2) you can rewrite the translation of script 3 (this second question I have manage with creating a temporary table).


I don't think the newest version of mysql will be on the server.

Thank you
Christine

try this

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 @ : alban.medici@xxxxxxxxxxxxxxxxx http://www.netcentrex.net ------------------------------

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux