为了个联合查询语句弄了1个小时
0 个评论
记录一下,以防以后又碰到相同情况又要找来找去
select count(*) as a from ( (SELECT aid,typeid,linkman,xiaoqu,fangxing,mianji,jiage,shijian,senddate FROM dede_addoninfos WHERE arcrank>=0 AND state=0 and typeid0) UNION (SELECT aid,typeid,linkman,xiaoqu,fangxing,mianji,jiage,shijian,senddate FROM dede_addoninfos9 ...
阅读全文