JOIN with multiple WHERE

[ld_be]

Hello


This is a solution with more controls of table PROFILE_DATA.

SELECT USERS.Name
FROM USERS
INNER JOIN PROFILE_DATA AS PROFILE_DATA_1
ON USERS. Ident = PROFILE_DATA_1.Owner
AND PROFILE_DATA_1.Name = 'AreaType'
AND PROFILE_DATA_1.Value = 'Rural'
INNER JOIN PROFILE_DATA AS PROFILE_DATA_2
ON USERS. Ident = PROFILE_DATA_2.Owner
AND PROFILE_DATA_2.Name = 'Country'
AND PROFILE_DATA_2.Value = 'United Kingdom'


Greetings
ld_be