问题描述:

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 a. and 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.

相关阅读:
Top