JOIN CONDITION

Hi

I have two catalogs :
- Ads
- Advertisers

I'd like to use Catalog List module to display the advertisers who have ads in a given city ("city" is a field in the first catalog)
How can I do that ?

Aida

I am not sure if the condition field can contain advanced enough conditions, but try adding "id in (select distinct(pid) from ads where city='amsterdam')". I assumed pid is a field in ads by with there parent is the advertiser and you can only use one list for one city.

Great it works!

Thank you for your quick reply and help