Mark Dyer wrote:
>
> Hello, I'm unsure how to write the follow query, Please can someone
> assist.
>
> I am writing in short hand the basis of the two queries I would like to
> combine. The object is to select all the products that have not meet the
> min sale requirements so I can send myself a
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 insta