hope i can get some help on this one as im not brilliant with my database scripts.
I have table "A" and table "B", table "A" contains information on a portfolio and table "B" is a joining table which connects this table to a user of the system with a 1-to-many relationship.
I am looking to return all records in table "A" that are not connected to a user in table "B"
i have tried this
SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.userid <> 1
but i know this is incorrect but cannot figure out myself how to achieve what i want.
Hopefully someone can point me in the right direction.