7webcreator
Member
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
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