两张表合为一张表查询

引用块内容

---

这里是简单的实现

select title,C_TIME from notice_listunion select WX_TITLE,C_TIME from message_contentorder by c_time desc;这里是在项目中具体用到的数据解决问题的方案*两张表要查询出作为一张表的数据类型一定要一致*select @rownum:=@rownum+1 AS ID ,a.* from(SELECT @rownum:=0) r ,(select URL WX_DETAIL,RESOURCE label,MAIN WX_MAIN,DATE_FORMAT(c_time,'%Y-%m-%d %H:%i') createtime  from notice_list union SELECT m.WX_DETAIL ,if(m.MESSAGE_ID=0,'重要事件',(SELECT GROUP_CONCAT(NAME) from message_type where is_mixed(ID,m.MESSAGE_ID)=1)) lable,m.WX_MAIN,DATE_FORMAT(m.C_TIME,'%Y-%m-%d %H:%i') createtime FROM message_content m order by createtime desc )aLIMIT 0,10