I have need of a query that selects all records that have an id that is not present in another table.
Select all from table_1 where field_id is not in table_2.field_something
Limitations: MySQL server 3.23
I tried the example off the MySql Reference page, only adjusting the fields and tables:
LEFT JOIN shop_products
WHERE shop_products_pages.product IS NULL;
But it fails to produce the desired result.
With kind regards
Ramses aka x_terminat_or_3
In the past my questions got misinterpreted, so to save us both some time I rephrase the question:
How to select those rows that have ids NOT PRESENT in another table. For the other table, instead of id, use product field. And it has to work on MySql 3.20