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

[Iulia Tamas]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20111123/53977e45/attachment.html