Need help with an update statment

[jayjabour]

LKBrwn_DBA,
thank you however when I run your update it updates 2 million rows, which conuses me becase is I just run the SELECT '?'
FROM APPOINT
WHERE APPOINT.Date=TRX.TreatmentDate
AND APPOINT.Patient=TRX.Patient
AND APPOINT.Clinic =1320
AND APPOINT.Type IN (0,1,2)
it only returns 377 rows.