Re: sql comparison and flag

bigbinc wrote:
> I need to compare two tables and print the differences(vbscript). Is
> there a quick sql way to do this. Otherwise I have a O(n^2) problem.
>
> What I am doing now is getting the data from the 2nd table first and
> then printing the 1st table and checking if the value matches the 2nd
> table. O(n^2)
>
> lets say I have ids
>
> Get Table 2 data
>
> 3 4 5
>
> Print Table 1 and Flag:
>
> 1 - no O(n)
> 2 - no O(n)
> 3 - yes O(n)
> 4 - yes O(n)
> 5 - yes O(n)
> 6 - no O(n)
>
> Is there a better way?

Define better.

(SELECT * FROM TABLE1
MINUS
SELECT * FROM TABLE2)
UNION
(SELECT * FROM TABLE2
MINUS
SELECT * FROM TABLE1) Received on Sat Oct 25 2003 - 23:57:54 CEST