Apologies if this is a stupid question but my brain has decided to switch off and I cant work out how to do what i need.
What am i trying to achieve?
I have 2 tables, one table lets say Accounts and another table called Equipment.
On the accounts there's a marker which will say if that account has a "Cooler" installed (called Cooler_Installed) another marker to say if an "Ice Maker" is installed (called Ice_Installed) and they're both a TRUE or FALSE value.
On the Equipment table it contains Equipment ID, Account ID and Equipment Type (value as 'COOLER' OR 'ICE'). There could be 2 rows of data in this table if an account has both a Cooler installed and also an Ice Maker.
What I'd like to do is run an SQL query which will display all the accounts that have the markers on the account that DONT actually have equipment installed anymore.
i.e. Account ID 1234 has Cooler_Installed = TRUE and Ice_Installed = TRUE on the account, but the ice maker has been removed from that account as no record in the equipment table with the Account ID 1234 and the Equipment Type as ICE exists anymore.
Based on the example above I'd like the output to display all the Account IDs and the Equipment Type where the equipment is no longer installed. So based on the example above it would be:
I hope that makes sense and thank you in advance.