tommyboyau
Programmer
Hi guys.
This is the scenario. I have a query which has run and was sucessful. It isolted the 'matters' which had a variable associated with them called ClientNumber. I have done a SELECT INTO statement which has outputed my results into a table called QueryOutput.
So in my QueryOutput table I have a list of MatterNumbers (ID's essentially).
Now I would like to genereate a list of the MatterNumbers which DONT appear in the QueryOutput table. That is to say, lets say I have 100 main matter records. 20 of those match my early query with the client number variable.
I was to make a query now which will only return the other 80.
Thanks in advance,
Tommy
This is the scenario. I have a query which has run and was sucessful. It isolted the 'matters' which had a variable associated with them called ClientNumber. I have done a SELECT INTO statement which has outputed my results into a table called QueryOutput.
So in my QueryOutput table I have a list of MatterNumbers (ID's essentially).
Now I would like to genereate a list of the MatterNumbers which DONT appear in the QueryOutput table. That is to say, lets say I have 100 main matter records. 20 of those match my early query with the client number variable.
I was to make a query now which will only return the other 80.
Thanks in advance,
Tommy
