Finding missing records

[isciberras]

Hi everyone, 

I need some help, I have a table with teams and their associated assets as shown in the table below 

Team	Assets
A	books
B	books
C	books
A	Radio
B	Radio
C	Radio
D	Radio

So from the table above I can see that Team A,B,C have books however Team D does not. We can identify that a Team D exists because Team D has a radio. 

Does anyone know what syntax I can write to identify that team D does not own the asset 'books'

Thanks,

Isaac

[sunny_talwar]

Where exactly are you looking to show this information? and do you just need to display the name of the Team which doesn't have all the assets or do you need to display the name of the Asset as well?

[isciberras]

Thank you for your help. 

Im hoping to create a table which looks like:

Assets	Team that does not have Asset
Books	D

[Anil_Babu_Samineni]

If source having like below including your sample data, Then what is the expected output?

Team, Assets
D, books
E, books
F, Radio