ORACLE-WITH用法

WITH A AS
(SELECT * FROM TMP_XM_X1 
UNION 
SELECT * FROM TMP_XM_X2
UNION 
SELECT * FROM TMP_XM_X3)

SELECT IMLITM,IMPRP4,A.TGQPRP4 
FROM PRODDTA.F4101,A WHERE IMLITM=A.TGQLITM AND A.TGQPRP4 LIKE 'B%'

with好像只能在select语句中使用,我在update语句中使用一直报错,老是提示说少select