Thank you! I can't believe I forgot about 'invert selection'!
Chris A. -----Original Message----- From: Arneson, Bronwyn [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:49 PM To: 'Chris Alexander' Subject: RE: MI-L FW: Select NOT Within Chris You can run that query and get the results of the sales prospects within a region and then using the "invert selection" tool (white arrow with black box around it) should give you the sales prospects outside that region. I'm not sure how intersects are dealt with though ... someone else might have a better answer. Cheers Bronwyn Arneson GIS Officer, Telecommunications Dept. Communications, IT & the Arts Canberra, Australia -----Original Message----- From: Chris Alexander [mailto:[EMAIL PROTECTED] Sent: Wednesday, 14 January 2004 9:42 To: '[EMAIL PROTECTED]' Subject: MI-L FW: Select NOT Within Hello, Is there a way to select points from one table that are NOT within a different polygon table? I want to find sales prospects that fall outside of a region. My statement can't be verified - I get the error 'Found [within] while searching for [like]'. Is there a way to express this join? Thanks very much! Chris K Alexander Marketing Data Analyst Advanced TelCom Group 19 Old Courthouse Square, Santa Rosa, CA 95404 Phone: 707-284-5395 Fax: 707-284-4259 [EMAIL PROTECTED] www.callatg.com <http://www.callatg.com/> _________________________________________________________________________ The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Security Advisor of the Department of Communications, Information Technology and the Arts, telephone (02) 6271-1880 and delete all copies of this transmission together with any attachments. _________________________________________________________________________ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9860
