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.
