select * from (
select email.UUID as uid,email.UUID as uuid,re.receive_staff_id as peo,email.subject as subject,email.rank as rank,email.send_time as sendTime,email.is_stick as isStick from oa_email email,oa_email_rel re where re.email_id=email.UUID and email.send_staff_id = '"+form.getSendStaffId()+"' and email.status = '1104' union all select re.UUID as uid,re.UUID as uuid,email.send_staff_id as peo,email.subject as subject,re.rank as rank,email.send_time as sendTime ,re.is_stick as isStick from oa_email_rel re,oa_email email where re.receive_staff_id = '"+form.getSendStaffId()+"' and re.email_id =email.UUID and re.status = '1104') order by
sendTime 这样写可以吗
union all 支持排序吗
最新推荐文章于 2024-04-07 11:32:21 发布