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.
Crispin Corporations Inc.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]