I have this statement that works fine
SELECT * FROM tblstatus, tblstatus_to_accounts WHERE tblstatus.statid=tblstatus_to_accounts.statid AND tblstatus_to_accounts.aid = '10'
basically pulls all statid's from tblstatus that exist in tblstatus_to_accounts and the aid = 10
But I need the opposite also.
I am trying to get all records that do not equal 10 on tblstatus_to_accounts
I tried so many different things, but can't get it to work.
statid | name
id | statid | aid
Thanks in advance