MYSQL query help
| From: | Harpreet | Date: | Fri, 14 Dec 2001 14:34:26 +0000 |
| Subject: | MYSQL query help | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15030@lists.php.net to get a copy of this message | ||
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative
that would work?
select * from lib_asset_tbl where material_id <>'' and asset_id in (select
asset_id from lib_copy_tbl)
Help is appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.