Can someone tell me if this update query's sql looks ok. I'm thinking it might have some problems.

UPDATE tbl95view1 INNER JOIN tbl88view1 ON (tbl95view1.col36 = tbl88view1.col27) AND (tbl95view1.col13 = tbl88view1.col23) AND (tbl95view1.col2 = tbl88view1.col2) SET tbl88view1.col20 = tbl95view1.col35
WHERE (tbl95view1.col13=accountid) AND (tbl95view1.col35>=checkno);