Hi

I am having trouble converting a query that contains AND operator in JOIN into LINQ. For example, our sample query is

Code:
SELECT
   e.name, a.city
FROM
   Emp e INNER JOIN Address a ON e.id = a.emp_id AND e.country = a.country
WHERE
   e.prof = 'doctor'
The main thing that is confusing me how to deal with the last AND clause.