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. Fred Harpreet <[EMAIL PROTECTED]> wrote in message 000001c184ac$6ed6b250$38c8a8c0@harpreet">news:000001c184ac$6ed6b250$38c8a8c0@harpreet... > 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. > > -- 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]