Hi Mark,

Go to the SQL Select form and build the following query:

-------------start------------------
Select columns: *
from tables:    Accidents
where condition:        obj  within  any(select  obj  from  Wards  where  =
Name=3D"Buckinghamshire")
-------------end----------------


You can find more details in the MapInfo help, at SQL Select - =
Performing Subselects.

BRGDS


Mircea Baila
MobiFon, Romania
E-mail:  [EMAIL PROTECTED]
Web: www.connex.ro

-----Original Message-----
From: Stevenson, Mark [mailto:[EMAIL PROTECTED]]
Sent: 26 February, 2002 12:14 PM
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=20
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]=20

This footnote also confirms that this email message has been
swept by MailSweeper for the presence of computer viruses.=20

**** 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.



_______________________________________________________________________
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.

Reply via email to