Re: Join three tables and specify criteria... I know this should be easy! - Mailing list pgsql-novice

Hi Ken and, again, thanks for your input,

2014-08-29 18:11 GMT+01:00 Ken Benson <Ken@infowerks.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');

user_id
1
2

And see also my reply to Naresh about if there's only one
language required.

Paul...

--
 
linehanp@tcd.ie
 
Mob: 00 353 86 864 5772