I'm having a problem with the following JOIN:
SELECT a.id as a_id, b.id as b_id
FROM tables.table_a as a
JOIN tables.table_b as b
ON a.id = b.id
This seems pretty basic to me, but despite the
b. prefixes I'm getting the following error message:
Error: Conflicting names in JOIN output: field id is present in both side of the JOIN.
Is this behavior known?
I had this same issue and resolved it by checking the "flatten results" box in the hidden options when writing to a table.