If your road tables has a column with unique IDs you can use a combination of a sub select and a grouped join:
Select * from ROADS
Where ID In
(
Select ROADS.ID
From ROADS, MAPSHEETS
Where ROADS.OBJ Intersects MAPSHEETS.obj
Group By ROADS.ID
)
into Selection
I must admit this is the first time I have tried it so I wasn’t sure if MapInfo Pro supported a join in a sub select, but it does.
Peter Horsbøll Møller
EMEA Channel Enablement Specialist
Location Intelligence | MapInfo
M: +45 29 133 769
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.