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