SELECT zg.ZGname, ck.CKname, ck.CKkind, zg.ZGjob, zg.ZGsal FROM ZG zg
INNER JOIN CK ck ON ck.CK# = zg.CK#
WHERE ck.CKname = '配件' OR ck.CKname = '整机'
SELECT bm.Zlede, ck.CKleader, ck.CKname, ck.CKkind FROM ZCBM bm
INNER JOIN CK ck ON ck.BM# = bm.BM#
WHERE ck.CKloca <> '二分厂'
UPDATE ZG SET ZGsal = ZGsal*1.05 WHERE CK# = 'Col15' AND (ZGjob = '负责人' OR ZGjob = '技术员')
SELECT zg.ZG#, zg.ZGname FROM ZG zg WHERE zg.ZGsal > (SELECT MAX(ZGsal) FROM ZG WHERE CK# = 'C033') ORDER BY zg.ZGsal DESC