SQL
AخA
#DESCRIBE user_groups;
SELECT * FROM
(SELECT user_name as extendedmovers FROM user_groups AS ug_pm JOIN user ON ug_user = user_id WHERE ug_group = 'extendedmover')
FULL OUTER JOIN
(SELECT user_name as filemovers FROM user_groups AS ug_fm JOIN user ON ug_user = user_id WHERE ug_group = 'filemover')
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.