But - you only want the id/name for a person that speaks ALL of the languages specified?
Or any user that speaks ANY of the specified languages?
Or Id/name/languages spoken?
What is the exact output you're looking for?
Says,
Ken
From: Paul Linehan [mailto:linehanp@tcd.ie] Sent: Friday, August 29, 2014 10:42 AM To: Ken Benson Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Join three tables and specify criteria... I know this should be easy!
> Whoops: > Should be WHERE ul. iso_code IN ('EN','DE')
but
SELECT DISTINCT u.user_id FROM user u JOIN user_language ul ON u.user_id = ul.ul_user_id JOIN language l ON ul.ul_iso_code = l.iso_code WHERE ul.ul_iso_code IN ('EN','DE');
gives
user_id 1 2
And see also my reply to Naresh about if there's only one language required.