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 <[email protected]> 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 > [email protected] > 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 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
