Pre-filter syntax in databasejoin element

[7webcreator]

Hello,

Can someone tell me if my syntax below is correct, please? I would like to gather users who belong to 2 different groups.

WHERE {thistable}.`name`
IN ( SELECT j25_users.name FROM j25_users, j25_user_usergroup_map
WHERE j25_users.id = j25_user_usergroup_map.user_id
AND j25_user_usergroup_map.group_id = 9
AND j25_user_usergroup_map.group_id = 14)

My parameters:
Joomla version 3.4.3
Fabrik 3.3.2

Thank you

 

[troester]

IN ( SELECT j25_users.name FROM j25_users, j25_user_usergroup_map
WHERE j25_users.id = j25_user_usergroup_map.user_id
AND (
j25_user_usergroup_map.group_id = 9
OR j25_user_usergroup_map.group_id = 14)
)

 

[7webcreator]

Hi Troester,

Thank you for your prompt reply. Unfortunately, I got an error message with your syntax. I tried this way instead

WHERE {thistable}.`name`
IN ( SELECT j25_users.name FROM j25_users, j25_user_usergroup_map
WHERE j25_users.id = j25_user_usergroup_map.user_id
AND j25_user_usergroup_map.group_id = 9
OR j25_user_usergroup_map.group_id = 14)

and I got all the list. I just want to have group 9 and 14. Please note that this syntax goes for the database join element.

 

[troester]

I got an error message with your syntax.: which one?

you need brackets to group the OR
(
j25_user_usergroup_map.group_id = 9
OR j25_user_usergroup_map.group_id = 14)

or you can do
WHERE {thistable}.`name`
IN ( SELECT j25_users.name FROM j25_users, j25_user_usergroup_map
WHERE j25_users.id = j25_user_usergroup_map.user_id
AND j25_user_usergroup_map.group_id IN ( 9,14)
)

 

[7webcreator]

Thank you very much. It is working now just fine with your last syntax.