[mapguide-users] Join between an Oracle spatial table and a view

Zac Spitzer zac.spitzer at gmail.com
Wed Nov 23 07:56:43 EST 2011


just create a view in oracle and add the spatial metadata, search the
list archives for more info

On Wed, Nov 23, 2011 at 11:41 PM, Iulia Tamas <iulia_tamas30 at yahoo.com> wrote:
> Hello,
>
>     I'm trying to make a join between an Oracle spatial table and a view
> (non-spatial view from Oracle) . This join is made in Mapguide Studio, in an
> King Oracle data connection
> In the first table are about 75 rows, while in the non-spatial view I have
> 33209 rows. After I make the join, the resulting table has 2 rows, instead
> of 75 (all the rows from the table have a matching row in the view).
>    I'm using Mapguide 2.2, King Oracle version 0.8 , on a 64 bit plateform
>    Are joins between spatial table and non-spatial views possible? If yes,
> what do I do wrong?
> Thank you,
> Iulia
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>



-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168


More information about the mapguide-users mailing list