RE: [PHP] MySQL PHP issue?
| From: | Jay Blanchard | Date: | Wed, 27 Apr 2005 19:29:02 +0000 |
| Subject: | RE: [PHP] MySQL PHP issue? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-214029@lists.php.net to get a copy of this message | ||
[snip]
OK, I have check all the mysql doc and php docs on using exists in the
query, but it seems I still can not get the query to work. Here it is:
SELECT * FROM icisp.account WHERE id in (select oldaccountID from
BillMax.account)
Or Using
sELECT * FROM icisp.account WHERE id exists(select oldaccountID from
BillMax.account)
Anyone have any idea what I'm doing wrong?
[/snip]
Asking a MySQL question on a PHP list? *slaps knee!*
What version of MySQL are you running, does it allow sub queries?