APPLYMAP comma separated with more values possible?

[#1]

Hello,

I Currently have following code (example):

mapcity:
MAPPING LOAD
[PROVINCE.Province],
[PROVINCE.City]
Resident PROVINCE;
CITY: 
Load   APPLYMAP ('mapcity', CITY.Province)          as CITY.City,
          .....,
          .....,
From [$(Path)\CITY.qvd]

Because There are more City's in every province it will still only add 1 City to CITY.City.

Is there a possibility that it will add more City's to CITY.City seperated with a comma (,)?

Or do i need to use something else then mapping?

Thanks a lot.

[Gysbert_Wassenaar]

No, you need to use a join instead if you want all the cities added to the provinces.