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 into table_merged
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 table1.
أكثر...
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 into table_merged
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 table1.
أكثر...