Select d.table_c.*
from (with table_c as (select *
                       from table_a)
      select *
      from table_b
      where table_a.id = table_b.id) as d

;WITH table_c
as
(SELECT * FROM table_a)
SELECT *
from table_b b
INNER JOIN table_c c on c.id = b.id