[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? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
