From surenkid, 1 Month ago, written in MySQL.
Embed
  1. -- use smwx;
  2.  
  3. SELECT s.esid,s.storename,u.employee_code,u.`name`,u.mobile,u.position FROM `smwx_wxqy_user` u
  4. LEFT JOIN smwx_store s on u.storeid = s.id
  5. where u.identity =  'STORE_MASTER'
  6. ORDER BY s.esid