Bit of a weird issue. I have made changes to 6 queries. These all have a column with the same name (product id).
When I apply the changes it fails. The message contains the yellow warning sign and the message says
The name ‘product id’ is already used for a column on table ‘Sales’. Choose a different name.
I am currently working on fixing this but not sure what caused it or why. I have multiple columns that appear in more than one table. All of my joins have the same column in the two joined tables.
So far I have
- renamed the offending column on the Sales table - no change in the error message.
- Changed the data type as I noticed on one query it was text and another ABC123 - which I assume is alphanumeric or general.
Any idea why this message is happening?