根据两个字段进行排序 其中一个字段按照中文排序
select a.*,b.charge from sys_orguser a,sys_project_org_user b where b.center_id='' and b.project_id='' and a.id=b.user_id order by b.charge DESC,convert(a.realname using gbk) asc
删除量表关联数据
delete t1,t2 from sys_project_org_user t1, sys_orguser t2 where t1.center_id='' and t1.project_id='' and t1.user_id=t2.id