Paul
Something like:
Select * from Cambridge_Customers_V
Where Cambridge_Customers_V2.Obj within Cambridge_90.Obj
And Cambridge_Customers_V2.Obj not within
( Select * from Cambridge_90)
HTH
Terry
-----Original Message-----
From: Paul Wilkinson [mailto:[EMAIL PROTECTED]
Sent: 11 October 2005 15:01
To: Terry McDonnell
Subject: MI-L Map Info SQL
Dear Group,
I have plotted 3 depots each with isochrones around them from drive time
information. Which overlap in some areas.
I am trying to use SQL to find customers that are within one Isochrone
but not another. I can use SQL to get customers within one Isochrone,
as below.
Cambridge_Customers_V2.Obj within Cambridge_90.Obj
However I need a statement that allows me to make more than one query at
a time.
For example something like:
Cambridge_Customers_V2.Obj within Cambridge_90.Obj but not within
ST_Albans_60.obj
Although I can not get this statement to work.
Any advice you have would be of great help.
Cheers
Paul
PRIVACY & CONFIDENTIALITY
This e-mail is private and confidential. If you have, or suspect you
have received this message in error please notify the sender as soon as
possible and remove from your system. You may not copy, distribute or
take any action in reliance on it. Thank you for your co-operation.
Please note that whilst best efforts are made, neither the company nor
the sender accepts any responsibility for viruses and it is your
responsibility to scan the email and attachments (if any).
This e-mail has been automatically scanned for viruses by MessageLabs.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 18206
