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

[Gabriele Monfardini]

> 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'?

Why not use a view? Database are way faster to combine data, it is their job.

Regards,

Gabriele