[mapguide-users] Label for multiple records from one-to-many join

[Jason Birch]

I don't think that's possible.  You may need to link the databases and
perform the join on the database.  With SQL 2008, you can create CLR-based
aggregate functions:

http://msdn.microsoft.com/en-us/library/ms182741.aspx

<http://msdn.microsoft.com/en-us/library/ms182741.aspx>Jason

On 15 July 2010 02:13, bishmanly wrote:

> Hi I have a layer based on a database table with a one-to-many join to
> another database table (1 'X' to many 'Y').
>
> Both tables are in SQL Server 2008 and I am using MGOS 2.0.
>
> I can create an expression for a label showing properties from 'X' and
> one random record from 'Y'.
>
> How can I create an expression for a label to show properties from all
> the records from 'Y'?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100715/e9ca2152/attachment.html