>SELECT * ; > FROM crsTestAcctContiUniCont; > WHERE crsTestAcctContiUniCont.iTransact NOT IN (SELECT iTransact FROM TransHist) ; > INTO CURSOR crsUpdate >If I'm reading you right, this will give all crsTestAcctContiUniCont records that have a match in TransHist (using the iTransact) but differ in any one of the other fields. It will also union in all the crsTestAcctContiUniCont records that have no match in TransHist. If I remember correctly the ORs will stop processing as soon as any one of them is true.
select ; TA.* ; from ; crsTestAcctContiUniCont TA ; inner join ; TransHist TH ON ; TA.iTransact = TH.iTransact ; AND (TA.Field1 # TH.Field1 ; OR TA.Field2 # TH.Field2 ; OR TA.Field3 # TH.Field3 ... ) ; union ; select ; TA.* ; from ; crsTestAcctContiUniCont TA ; where ; TA.iTransact NOT IN (SELECT TH.iTransact FROM TransHist TH)