select table_a.id as "id1", table_b.id as "id2", ... #### select "id1" = table_a.id, "id2" = table_b.id, ...