Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I'm trying to execute a SQL query in MapInfo, and want to change some of the column names to something more readable. The SQL command 'AS' doesn't seem to work - is there a MapInfo equivalent?
MapInfo SQL doesn't use the AS keyword. You can just add the alias in quotes after the column name.
SELECT col1 "Bar" FROM Foo
Required, but never shown