bwj_server/src/dsb/com/cnd3b/restcontroller/enterprise/data/SQL/在线用户实时.sql

SELECT t1.tenterprise_userid, t1.frole, t1.fname, t1.fsex, t1.fphonenumber, t2.ftype, t2.fagentname
FROM tenterprise_users as t1
         LEFT JOIN tagents as t2
                   ON t1.tagentsid = t2.tagentsid
WHERE t1.tenterprise_userid IN $tenterprise_userid$