Yes, thats the trick. Thanks for your help. This list is great.
Stokes Jonathan wrote:
>
> 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.
