R: [PHP] R: [PHP] MySQL Question
| From: | Roberto Sartor | Date: | Mon, 31 Jul 2000 13:01:06 +0000 |
| Subject: | R: [PHP] R: [PHP] MySQL Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-9153@lists.php.net to get a copy of this message | ||
Sorry, but I referred to standard SQL. Then, use join
Ciao
Roberto
> -----Messaggio originale-----
> Da: Boget, Chris [mailto:Chris.Boget@wild.net]
> Inviato: lunedì 31 luglio 2000 15.03
> A: 'Roberto Sartor'; 'Simon Biela'; php-general@lists.php.net
> Oggetto: RE: [PHP] R: [PHP] MySQL Question
>
>
> > if you need only columns from table "author", do:
> > "SELECT au.* FROM author au WHERE EXISTS (SELECT 1 FROM
> > article ar WHERE au.ID_author=ar.ID_article)".
> > It's a little fast than a join (SELECT au.* FROM article
> ar,author au
> > WHERE au.ID_author=ar.ID_article)
>
> Except that, unless I missed something very recently, mySQL cannot
> do subselects...
>
> Chris