Reserved words used as column names

[gcamps]

I have a table with a column called 'from'. Is there a way to run the following code without a message error?

UPDATE FILE_NAME SET FROM='Germany' WHERE MADE='VW'

[Admin]

Yes, please use syntax as follows:

Code: Select all

UPDATE table1 SET table1.from = 'Germany' WHERE made='VW'

[gcamps]

Thanks a lot, it worked