Results 1 to 3 of 3

Thread: JOIN CONDITION

  1. #1
    User
    Join Date
    01-26-10.
    Posts
    37

    Default 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

  2. #2
    Experienced user
    Join Date
    01-12-10.
    Posts
    814

    Default Re: JOIN CONDITION

    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.

  3. #3
    User
    Join Date
    01-26-10.
    Posts
    37

    Default Re: JOIN CONDITION

    Great it works!

    Thank you for your quick reply and help

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •