Hi Soren
Map Info does not want "And" if you are selecting from one field, but it rather wants
"Or". So simple run the same query and put "Or" instead of "And".
Regards,
Norman Mabunda
Manager: GIS and Databases
[EMAIL PROTECTED]
+27 12 312 0843 (Tel)
+27 12 312 0642 (fax)
+27 73 265 927
Hello Soren,
You've fallen into a common trap when learning SQL! Sometimes AND's and OR's
are the opposite to what one would express in spoken language. In this case,
I assume you want to select records from any of the three cities. In this
case you need to use OR instead of AND. What's happening
Nick,
I believe that the structure you want cannot be achieved using a query. The
best result you can get from a query is:
Region1 Tile1
Region1 Tile2
Region1 Tile3
Region2 Tile1
Region2 Tile3...
You can, however, use this resulting table to generate a r
