B = select * from tblb
C = select * from A join B
WITH a AS (select * from tbla), b AS (select * from tblb) select * from a join b