Login

pippuccio76 · 08-31-2022, 11:18 PM

(08-31-2022, 10:42 AM)ngatcharius Wrote: Hi Pippuccio76
SELECT * FROM material WHERE id NOTIN (SELECT id_materiale FROM location)
in this query, it will select first all id_material that is in a location and it will select all material that not match the provide id.
Hope it help.

it return 0 rows , this query SELECT id_materiale FROM location return 7 record with id_material and other record with NULL ( I have recently started inserting)

EDIT:

It work in this way

SELECT * FROM material WHERE id NOTIN (SELECT id_materiale FROM location WHERE id_materiale IS NOT NULL)