SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid
FROM(
SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid
FROM eagles
UNION
SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid
FROM eagles2
)
temp
GROUP BY eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid
HAVING count(eagleid) > 1
-----Original Message-----
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 1:32 PM
To: CF-Talk
Subject: RE: dta comparison from identical tables, but different data
SELECT col1,col2,etc FROM
(
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]
