Hi. Could I use this to select data from two tables or only select from one table ar a time?
@GISCoordinated
3 жыл бұрын
Not by default. You could use the MapBasic Window to copy/paste the SQL and change the table name as needed. If its lots of tables, you could also use Notepad++ to edit a Workspace which has all your selected in it and each line would be executed as the workspace loads (which can be done in Mapbasic of course but using the WOR is simpler). With Mapbasic, you could make a little tool that looks for all open tables and loops through them, executing the query on each one.
Пікірлер: 2