2014-08-29 17:59 GMT+01:00 Ken Benson <Ken(at)infowerks(dot)com>:
Hi Ken, and thanks for your input,
but there's no u.user_language field - user_language is a
joining table - otherwise, I'd have to have a record in the
user table for each language spoken which would not
be very normalised (or elegant :-) ).
Paul...
> 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 u.user_language IN ('EN','DE')
--
linehanp(at)tcd(dot)ie
Mob: 00 353 86 864 5772