I already have this done in Foxpro, scaning and comparing data in 2 tables, but is there a way
to do this in SQL Server using SQL???
Basically I have 2 tables that are identical in structure, but the data in one table may not be the same as the other, so I want to find out where the discrepancies are. Is this possible?

Thanks!