si_carter_987654321 wrote:
I have two almost identical sets of records, what would be the most efficient
way of detecting records that are different in the table based on a single
column?
If you only want to view the difference, I recommend using FBCopy with
XH option. It creates a nice
Cheers I will check it out :-)
Si
On 24 December 2011 03:19, Virna Constantin costel...@yahoo.com wrote:
**
SELECT S.*,M.col3 as col3m
FROM SECND S
inner join MASTER M on S.COL1=M.col1 and S.COL2=M.COL2
where S.COL3M.COL3
In the example above
SELECT S.*,M.col3 as col3m
FROM SECND S
inner join MASTER M on S.COL1=M.col1 and S.COL2=M.COL2
where S.COL3M.COL3
In the example above the last record in secondary table is different so this
is the only row I would like to return, if that makes