Chris, You might try something like:
SELECT * FROM points WHERE not obj within any (SELECT obj FROM polygons) INTO points_outside - Ian ----- Original Message ----- From: "Chris Alexander" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 13, 2004 3:42 PM 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/> > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9863
