Home Forums SQL Server 7,2000 General syntax help! RE: syntax help!
DAVNovak
Hall of Fame
Points: 3120
More actions
July 23, 2003 at 9:04 am
#466606
Assuming the cust_id = dup_code, why not do a simple select count of all matching records between the two tables
SELECT @Count = COUNT(t1.*)
FROM unique_cust t1 INNER JOIN unique_cust t2 ON t1.cust_id = t2.cust_id