(
SELECT col1,col2,etc FROM TABLE1
UNION
SELECT col1,col2,etc FROM TABLE2
) temp
GROUP BY col1,col2,etc
HAVING count(col1) > 1
Marlon
> -----Original Message-----
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 17, 2004 12:36 PM
> To: CF-Talk
> Subject: SQL: dta comparison from identical tables, but different data
>
> Got a table with approximately 11 columns and 1 million records. I
have a
> another table with the same columns and records but want to compare if
the
> data is different. Changes could be in one or more of the columns. How
can
> I compare these. MS SQL2000?
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
