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
From ROADS, MAPSHEETS
Where ROADS.OBJ Intersects MAPSHEETS.obj
Group By ROADS.ID
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:
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
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.