RE: [PHP] R: [PHP] MySQL Question

From: Date: Mon, 31 Jul 2000 13:02:33 +0000
Subject: RE: [PHP] R: [PHP] MySQL Question
Groups: php.general 
Request: Send a blank email to php-general+get-9152@lists.php.net to get a copy of this message
> 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

« previous php.general (#9152) next »