sql spørgsmål
Er det muligt at gøre denne sql linie lidt kortere--------------------------------------------------------
SELECT phpbb_users.user_id, phpbb_users.username, phpbb_groups.group_name, phpbb_users.user_password
FROM phpbb_users, phpbb_groups, phpbb_user_group
WHERE phpbb_users.user_id = phpbb_user_group.user_id
AND phpbb_user_group.group_id = phpbb_groups.group_id
AND phpbb_groups.group_name = 'Members'
AND phpbb_users.username =".$_REQUEST["user"]."
OR phpbb_users.user_id = phpbb_user_group.user_id
AND phpbb_user_group.group_id = phpbb_groups.group_id
AND phpbb_groups.group_name = 'Leaders'
AND phpbb_users.username =".$_REQUEST["user"]."
OR phpbb_users.user_id = phpbb_user_group.user_id
AND phpbb_user_group.group_id = phpbb_groups.group_id
AND phpbb_groups.group_name = 'Adminstrator'
AND phpbb_users.username =".$_REQUEST["user"]."
ORDER BY phpbb_groups.group_id DESC
--------------------------------------------------------