Cacher is the code snippet organizer for pro developers

WITH ATABLE AS (
 SELECT AA,BB,CC FROM ATABLE
), 
BTABLE AS (
 SELECT * 
 FROM VIEW
 WHERE (KEY1,KEY2,KEY3) IN (SELECT AA,BB,CC FROM ATABLE)
)
SELECT *
FROM ATABLE A
LEFT JOIN BTABLE B ON A.AA=B.KEY1 AND A.BB=B.KEY2 AND A.CC=B.KEY3