Try this: Select * >From LAYER_A Where OBJ Intersects Any (Select Buffer(OBJ, 12, 20, "m") From LAYER_B) If you want to use the SQL dialog just leave out the Select, From and Where keywords and copy the line to the appropriate field in the dialog or just copy the entire statement and insert it in the MapBasic windowm ark it all and hit ENTER I assumed that your 20m = 20 meters ?? Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 5260 Odense S. Denmark Tel + 45 6311 4900 Dir +45 6311 4908 Mob +45 5156 1045 Fax + 45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk <http://www.cowi.dk/>
________________________________ From: Rob Rowell [mailto:[EMAIL PROTECTED] Sent: Thu 24-Feb-05 10:06 To: MapInfo User Listing Subject: MI-L Buffer Qry from SQL or MB Window ? Hi all I've been caught away from my office and don't have my trusted resources with me. I want to be able to select all the objects for Layer A that are with 20m of Layer B objects (ie LayerA.objs that intersect the 20m Buffer of LayerB.obj 's) Does any one have the syntax to which I can run this from the SQL Query Dialog or the MapBasic Window Good luck Rob Rowell Insight GIS [EMAIL PROTECTED] www.insightgis.com.au ph +61 3 6234 5833 fax +61 3 6234 5899 mob 0418 127 152
