OpFlashpoint.org
Bringing the cold war to your desktop
Information
MySQL Error: Table 'sc_opflashpoint.ranks' doesn't exist
QUERY :
SELECT
u.user_id,
u.username,
r.rank_title
FROM sc_opflashpoint_forums.user_group ug, sc_opflashpoint_forums.users u
LEFT OUTER JOIN ranks r ON u.user_rank = r.rank_id
WHERE u.user_id = ug.user_id AND ug.group_id = 3
ORDER BY
u.username