Need to Update using SQL 2 tables with 2 key fields

[sheehaj]

Have 2 tables with more than 1 key field. Need to update 1st table using criteria from 1st table and 2nd table. Have done this previously but the tables had only 1 key field each (one to one relationship). Now have 2 key fields in first table and 3 key fields in second table (one to many relationship). Will update but most certainly not the correct accounts.
How can I add to the following?
UPDATE SHEEHAJ/SRVCOLI
SET ICLEAR = 20010124
WHERE IENTER < 20011001
AND ICLEAR = 0
AND ILOAN > 0004000000
AND ILOAN = ANY
(SELECT CLOAN FROM SHEEHAJ/SRVCOLC
WHERE CCOMM LIKE '%CC120%')