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.COL3<>M.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 sense. [Non-text portions of this message have been removed]
