Re: Subselect ?
| From: | Justin Patrin | Date: | Fri, 16 Jan 2004 16:40:51 +0000 |
| Subject: | Re: Subselect ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32450@lists.php.net to get a copy of this message | ||
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. ChrisMaybe 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. -- paperCrane <Justin Patrin> -- Question Everything, Reject Nothing