Use a unique value in the ward polygon to select it, for example you could use the name of the ward. In the where clause of the sql select dialog you would have something like:
wardtable.obj CONTAINS accidenttable.obj AND wardtable.name = "Ward Name" This should then select everything that is inside the named ward. ------------------------------- Kind Regards, Colin Henderson GI Developer Ordnance Survey Tel: +44 (0)2380 79 2327 mailto:[EMAIL PROTECTED] ------------------------------- -----Original Message----- From: Stevenson, Mark [mailto:[EMAIL PROTECTED]] Sent: 26 February 2002 10:14 To: '[EMAIL PROTECTED]' Subject: MI-L Selecting points in a polygon Hi all Sorry I'm sure this is going to be a very simple answer. I have a polygon layer showing all county wards and a second layer showing accidents in the county as points. I need to select all accidents for a single ward I can produce the sql for all of the polygons but not for a single ward. All help appreciated. Mark Stevenson Room 803 County Hall Walton Street Buckinghamshire HP20 1UY 01296 383373 01296 382060 [EMAIL PROTECTED] www.buckscc.gov.uk/population/index.stm **** Buckinghamshire County Council E-mail Disclaimer **** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, the use of the information by disclosure, copying or distribution is prohibited and may be unlawful. If you have received this email in error please notify the system manager at [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MailSweeper for the presence of computer viruses. **** End of Disclaimer ********************************************* _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. *************************************************************** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *************************************************************** _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
