统计记录:
select count(*) as total from [!db.pre!]ecms_newsunion select count(*) as total from [!db.pre!]ecms_book
查询记录:
select classid,id,titleurl,title,newstime from [!db.pre!]ecms_news union select classid,id,titleurl,title,newstime from [!db.pre!]ecms_book order by newstime desc

上一篇：帝国CMS灵动标签调用复选框字段去除竖线分隔符号的代码
下一篇：帝国CMS怎么随机调用栏目
多表查询