There are several ways to get around the lack of subselect support in mysql.
For your situation you can simply use:
SELECT * FROM lib_asset_tbl, lib_copy_tbl WHERE lib_asset_tbl.material_id <>
'' AND lib_asset_tbl.asset_id = lib_copy_tbl.asset_id
of course, this will return a row for every instance of a many to many
relationship, so you may want to use a GROUP BY clause to reduce the number
of rows in the result.
Harpreet <[EMAIL PROTECTED]> wrote in message
> I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an
> 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.
> Harpreet Kaur
> Software Developer
> 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]