Hi People, my challenge seems simple but its beyond my capability. I need to match the members in my “searches” category who are seeking a specific service, to the members in my “trades” category who are providing the service wanted by the searcher. I get as far as matching the service wanted with the service provided along with the member id associated with the respective party. But I fall over when I try to capture the contact info from the “members" category to show the associated email and user name of the respective parties. This is the part I can do: SELECT trades.member_id, trades.srv_field, searches.member_id, searches.srv_field FROM trades, searches WHERE (trades.srv_field=searches.srv_field) group by trades.member_id Now the challenge to get the contact info from the “members” category to be assigned to the associated “searchers” person and “trades”person. This will let me develop a mail out list to inform people of prospective matches. I thought it would be simple?:eek:
