SQL: Selecting everything BUT

[darrel]

I have a table with 439 records in it. This table is linked to another,
which is related to a 3rd via a 4th relationship table.

I have a gigantic query that connects all this together AND (should) account
for files that aren't properly linked (for error checking).

The catch is that the query returns 430 records. So there are 9 orphaned
records that aren't quite matching my SQL query.

Is there any way to run a 'reverse' query in a SQL analyzer to see
everything BUT what is returned via the query?

-Darrel

[Manuel Socarras]

what about:

SELECT ... NOT (your gigantic query)

HTH,

manuel

darrel wrote:

> I have a table with 439 records in it. This table is linked to another,
> which is related to a 3rd via a 4th relationship table.
>
> I have a gigantic query that connects all this together AND (should) account
> for files that aren't properly linked (for error checking).
>
> The catch is that the query returns 430 records. So there are 9 orphaned
> records that aren't quite matching my SQL query.
>
> Is there any way to run a 'reverse' query in a SQL analyzer to see
> everything BUT what is returned via the query?
>
> -Darrel
>
>

[darrel]

> SELECT ... NOT (your gigantic query)

No, that won't work AFICT. That'd only work if I had a discreet WHERE
statement.

My query is a series of a couple joins and a few unions. There are all sorts
of relationships going on with the query and I'm trying to find out where
these 9 records are falling through my logic.

-Darrel