oracle的查询新增

INSERT INTO T_A( ID,A1,A2,A3,A4 )
SELECT
SEQ_XXX.nextval AS ID,
 B.B1 AS A1,
 B.B2 AS A2,
 C.C1 AS A3,
 C.C2 AS A4
 FROM T_B B 
LEFT JOIN T_C C ON B.ID=C.ID 
WHERE B.XX='0' AND C.XXX=1;