Error 3806: Table/view/trigger name is ambiguous in Teradata

In MLOAD or in BTEQ the error 3806 will come when the table name is not clearly mentioned in the RDBMS statements used for joins.
Secondly, if the table was loaded already in ML work table, there may be a chance of 3806 error.

Solution:
1. Drop the work table and ML tables.
DROP TABLE LOAD_WORK.TABLE_NAME
DROP TABLE LOAD_WORK.ML_TABLE_NAME
2. Check the syntax used. Mention the tables' names clearly for joins. i.e specify alias name for columns which are present in two or more tables