Help Center/
Data Lake Insight/
FAQs/
SQL Jobs/
SQL Job O&M/
Why Is Error "SQL_ANALYSIS_ERROR: Reference 't.id' is ambiguous, could be: t.id, t.id.;" Displayed When Two Tables Are Joined?
Updated on 2024-11-15 GMT+08:00
Why Is Error "SQL_ANALYSIS_ERROR: Reference 't.id' is ambiguous, could be: t.id, t.id.;" Displayed When Two Tables Are Joined?
This message indicates that the two tables to be joined contain the same column, but the owner of the column is not specified when the command is executed.
For example, tables tb1 and tb2 contain the id field.
Incorrect command:
select id from tb1 join tb2;
Correct command:
select tb1.id from tb1 join tb2;
Parent topic: SQL Job O&M
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot