Re: Join three tables and specify criteria... I know this should be easy!

I thought the user_id is all you wanted …

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(at)tcd(dot)ie]
Sent: Friday, August 29, 2014 10:42 AM
To: Ken Benson
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Join three tables and specify criteria... I know this should be easy!

Hi Ken and, again, thanks for your input,

2014-08-29 18:11 GMT+01:00 Ken Benson <Ken(at)infowerks(dot)com<mailto:Ken(at)infowerks(dot)com>>:

> 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.
Paul...

--

linehanp(at)tcd(dot)ie<mailto:linehanp(at)tcd(dot)ie>

Mob: 00 353 86 864 5772