I have 2 tables. One containing the suppliers and one containing the users for each supplier. I tryed to create a select statement which is bringing me only the suppliers that have no users.
SELECT suppliers.supplierid, users.supplierid,
FROM suppliers LEFT OUTER JOIN
users ON suppliers.supplierid = users.supplierid
So, the suppliers that have no user attached will have on the users.supplierid column the value = null. But I need only the suppliers that have the value null in users.suppliers
How do I write this condition? I tryed some ideas but didn't worked. Can anybody help me?
Thanks a lot,