Re: Re: Subselect ?

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

 



Mensaje citado por Christine Clerc <x.clerc@xxxxxxx>:

> 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.

I think the problem was the selection of the database server. If you need special
features like sub-select you shouldn't have chossen MySQL.

By the way, I think it may be posible to build a query that does what you want, but
it would involve UNION and lots of quiery work.

-- 
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués          |   Programador, DBA
Centro de Telemática	|     Administrador
               Universidad Nacional
                    del Litoral
---------------------------------------------------------

-- 
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