I don't think so, that produces an outer join error since multiple point objects in one region would bring repeated region objects. You can get a list of points with the county region data associated with it, and point objects on the map.
You could identify the county a point resides in using UPDATE COLUMN menu, try adding a field in point table for County and updating the point table with the region table, specify a geographic operator in the join dialog, ****OR**** in the SQL dialogue, specify specific fields (instead of *)from both tables to bring together, again only the point objects will be there, To see the county outlines, simply add the region table back in with the query via layer control Also it was not clear if the person wanted all point objects or a return of point objects in a specified county such as Select * from Points, Regions where Region.obj CONTAINS Point.obj AND Region.CountyName LIKE "%Suffolk%" William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 - FAX (989) 773 1988 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Will Mitchell [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 1:14 PM To: [EMAIL PROTECTED]; MapInfo-L@lists.directionsmag.com Subject: RE: MI-L SQL question You can reverse the order of the tables in the SQL dialog, should return the first table's geography/polygon... Will Mitchell Mitchell Geographics, Inc. 496 Congress St Portland, ME 04101 ph 207.879.7769 fx 207.253.5756 www.mitchellgeo.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 10:30 AM To: MapInfo-L@lists.directionsmag.com Subject: MI-L SQL question Group, It slips my mind right know so, I have an SQL question. I have a point file and a county file for the US. I want to query all points that fall within the county and then give me the County Boundry file. I keep doing it getting the output of the point file. Any help? -------------------------------------------------------------------- Philip Lesnik Research Systems Analyst, Market Research General Growth Properties, Inc. 110 N. Wacker Drive BSC 3-13 Chicago, IL 60606 312-960-2998 312-960-5519 (fax) [EMAIL PROTECTED] -------------------------------------------------------------------- ----------------------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This e-mail including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. '' 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14788 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14794 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14813
