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
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
.e.
>
> select *
> frompoints, polygons
> where points.obj within polygons.obj
> group
> order
> intoselection
>
> hope this helps
>
> Jon
>
> -Original Message-
> From: David Booth [mailto:[EMAIL PROTECTED]]
> Sent: 07 February 2001