SELECT id, LEFT(Bbs_Title, 14) AS Bbs_Title, LEFT(User_name, 3)
AS User_name, test1,test2,
test3 = '内部论坛'
FROM (SELECT top 3 Bbs_MessageID AS id, LEFT(Bbs_Title, 14) AS Bbs_Title,
LEFT(User_name, 3) AS User_name, Bbs_Message_date AS test1,
ISTOP AS test2, test3 = '内部论坛'
FROM Bbs_Message
ORDER BY test2 desc,id DESC) a
UNION
SELECT id, Bbs_Title,
User_name, test1, test2,
test3 = '他山之十'
FROM (SELECT top 3 ArticleID AS id, LEFT(Title, 14) AS Bbs_Title, LEFT(Editor, 3)
AS User_name, UpdateTime AS test1, ISzhiding AS test2,
test3 = '他山之十'
FROM Article
where FBLBID=''
ORDER BY test2 desc,id DESC) b
相关文章
- STM32下一次程序后J-link不能识别问题解决
- IE10、IE11解决不能播放Flash的问题!
- 成功解决Win7 64位系统下GraphEdit 不能显示Directshow.net远程图表的问题
- ZT 解决Ubuntu下SublimeText3不能输入中文问题
- 解决Android单个dex文件不能超过65536个方法问题
- iOS 开发: 解决Xcode7.3 不能自动索引头文件,文件名等问题
- Oracle 监听服务强制被关闭不能启动 TNS识别问题解决
- ubuntu下usb不能识别问题解决
- 解决 eclipse buildpath的jar包不能复制到tomcat lib下的问题
- 解决statusStrip控件上的项目不能靠右对齐的问题