[mapguide-users] Is it possible to create join on join ?

[Kenneth Skovhede, GEOGRAF A/S]

Your table must have a primary key, otherwise selection will not work as 
expected.
If you are using views, you must create a special table to declare this.
Instructions are here:
http://www.sl-king.com/fdooracle/KingFdoClass.htm

Regards, Kenneth Skovhede, GEOGRAF A/S



Krunoslav skrev:
>
> Dave Wilson-3 wrote:
>   
>> For performance reasons if you are querying 2 tables on the same instance
>> it's much faster to create a view in the database than do a second join
>> which isn't currently supported anyway.
>>
>>     
>
> Ok, I created view on OracleXE, and I can make new layer using King.Oracle
> provider, and layer shows fine.
>
> But, there's one major problem: objects on this layer are not selectable.
> They are on the map, but when I click on some object, nothing happens. I
> checked in map properties, and layer is marked as selectable, but it is not.
> Any ideas?
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080724/c2cd3687/attachment.html