Help Center/
Data Lake Insight/
FAQs/
Problems Related to SQL Jobs/
Job O&M Errors/
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 2023-05-19 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: Job O&M Errors
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