This query is marked as a draft This query has been published by Vexations.

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.

Checking query status...