I am using SQL server 2008. I have 3 tables. Table a has 1 column aid, table b has 1 column bid and table c has 2 columns aid, bid. Is it possible to use one SQL statement that returns all the combination of aid and bid that does NOT exists in table c.
e.g. table a has 2 rows: a, b
table b has 3 rows 1,2,3
table c has 2 rows (a, 2), (b,1)
and I want to return record set to be 4 rows: (a,1), (a,3), (b,2), (b,3)
Thanks in advance for any help.