I'm fairly adept with the SQL Select in MapInfo, but I'm running into something that's got me a bit stumped.
I've got data in two tables that have a few columns in common. I want to join the tables and export them to a CSV, but I don't want to duplicate those columns. Unfortunately, something like this doesn't work:
SELECT table1.*, table2.A, table2.B, table2,C
From table1, table2
Where table1.match = table2.match
Is there a way to accomplish this? If it helps,
table2 will always have the same number of columns and the first five columns are present in