How to find what foreign relations don't exist...
Posted: Mon Aug 14, 2006 12:19 pm
I have a table which contains property information, with a unique id.
I have a table with client information, which has a unique id.
I have a table where it I calculate how 'relevant' the property is to the client.
Is there a way, using one query to find out which property id and client id pairs don't exist in the relevant table?
I have a table with client information, which has a unique id.
I have a table where it I calculate how 'relevant' the property is to the client.
Is there a way, using one query to find out which property id and client id pairs don't exist in the relevant table?