Yep that got it working. Thanks Mike Terry McDonnell <[EMAIL PROTECTED]> wrote: Mike
I haven't done this myself yet but does the below work? HTH Terry Select * from Table2 where table2.obj within Buffer( table1.Obj, 1, 100, "m") -----Original Message----- From: Mike Tonge [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 14:16 To: Terry McDonnell Subject: MI-L SQL selects Hi List I've got two MapInfo points tables and I wish to select all pairs where an object from one table is within 100m of an object in the other table. Can someone tell me the SQL syntax for doing this? Thanks Mike --------------------------------- How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! Photos --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17660 --------------------------------- Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail