Tony,
I share your frustration that only base tables can be joined dynamically.
Occasionally, I've been able to get away from saving the selection by nesting
the selection in the SQL statement. This technique works well from lookup tables.
Below is an example format using a lookup table.
Select * From {Table} Where {Column} = Any (Select {Column} From {Lookup Table}
Where .......)
This will select all the items in the table that match it in the lookup table.
Hope this helps.
Regards,
Sue Port.
www.spatialplus.com
>
>
>We are using data that is structured around the use of numerous tables.
>
>However, in Mapinfo as opposed to other GIS, building new layers or
>tables based on selections that are joined to other tables is laboured -
>unless I am not doing something right.
>
>Mapinfo won't allow selections on dynamic joins that are not "base
>tables" (i.e the concept of a database view or table definition isn't
>available).
>
>The user has to make a copy of the selection (i.e. save copy as) then
>build the next stage in the query to create a new table or layer.
>
>This does not seem to me to be particularly efficient.
>
>Does anyone have any ideas on building temporary or permanent tables on
>the fly without adding to the existing data sets with an "intermediate"
>layer, other than creating a "flat" table.
>
>Regards
>
>
>-----------------------------------
>Tony Elson
>
>GIS Analyst
>
>Geographic Technologies Limited
>PO Box 6015
>Wellesley Street,
>Auckland, New Zealand
>
>Ph: 64 9 379 2061 x107
>Fax: 64 9 379 2044
>Mobile: 025 278 4896
>Email: [EMAIL PROTECTED]
>[EMAIL PROTECTED]
>------------------------------------
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
>
>--------------------------------------------------------------------------------
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
