原帖由 zhoumo310 于 2013-01-15 10:21:14 发表 我想在一个位置能同时显示多个数据表中的推荐信息,请问灵动标签的sql该怎么写呢? |
[ecmsinfo]'select * from (select * from phome_ecms_表名1 where checked=1 and classid in (1610,1616) union select * from phome_ecms_表名2 where checked=1 and classid in (1289,1290,1291)) a order by newstime desc limit 100',100,40,1,24,54,0[/ecmsinfo]
网上找到的万能标签
|