Richard
David was right it is down to the order you put the tables in in the "From"
box. If you always put the points table first it will select the points and
vice versa i.e.
select *
from points, polygons
where points.obj within polygons.obj
group
order
into selection
hope this helps
Jon
-----Original Message-----
From: David Booth [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2001 09:16
To: 'Richard Maaranen'; [EMAIL PROTECTED]
Subject: RE: MI-L SQL select bug?
Hi Richard,
I'm pretty sure this will be down to the order you list the tables in the
"FROM" bit of the SQL statement. I think (though I'm not entirely sure) that
you get the objects from the first table in the list. Possibly.
---------------------------------------------
David Booth
Senior GIS Officer
Merseyside Information Service
> -----Original Message-----
> From: Richard Maaranen [SMTP:[EMAIL PROTECTED]]
> Sent: 07 February 2001 00:05
> To: [EMAIL PROTECTED]
> Subject: MI-L SQL select bug?
>
>
>
> I think this may be an SQL select bug. When I want to select all the =
> points from a point layer that fall within a polygon layer using SQL =
> select, sometimes it selects only polygons and sometimes it selects the =
> points. I can't seem to figure out exactly how to get it to select only =
> the points every time. I've tried both contains and within operators, =
> having different layers editable, etc. and it seems to be hit-and-miss.
>
> Does anyone know how to make sure that the only the points are selected =
> every time?=20
>
>
>
>
> _______________________________________________________________________
> 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.
_______________________________________________________________________
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.
