[Teradata][ODBC Teradata Driver][Teradata Database] Table/view/trigger name 'item' is ambiguous

Teradata Applications
Fan

[Teradata][ODBC Teradata Driver][Teradata Database] Table/view/trigger name 'item' is ambiguous

Hi there,

I ran a VBA to fetch data from Terada but got this error message.

[Teradata][ODBC Teradata Driver][Teradata Database] Table/view/trigger name 'item' is ambiguous.

But when I ran the SQL manually, it worked. Do you know why? Many thanks. Tai

2 REPLIES
Fan

Re: [Teradata][ODBC Teradata Driver][Teradata Database] Table/view/trigger name 'item' is ambiguous

Thank you!

Enthusiast

Re: [Teradata][ODBC Teradata Driver][Teradata Database] Table/view/trigger name 'item' is ambiguous

This might be because when you logon to sql assistant, the default database might have been set to the database where the item table/view/trigger resides. Modify this to qualify 'item' with the databasename and you should be good.

HTH!!

Krishna