--try這樣行不行SELECT dbo.bs_news.id, dbo.bs_news.title, dbo.bs_news.content, dbo.bs_treemenu.treename,dbo.bs_treemenu.treecode, dbo.bs_news.author, dbo.bs_news.addtime FROM dbo.bs_news INNER JOIN dbo.bs_treemenu ON dbo.bs_news.treecode = dbo.bs_treemenu.treecode where dbo.bs_treemenu.treecode like '01.01%' and dbo.bs_treemenu.treecode<>'01.01.03' and dbo.bs_treemenu.location<>2 union all select * from (select top 1 dbo.bs_news.id, dbo.bs_news.title, dbo.bs_news.content, dbo.bs_treemenu.treename,dbo.bs_treemenu.treecode, dbo.bs_news.author, dbo.bs_news.addtime FROM dbo.bs_news INNER JOIN dbo.bs_treemenu ON dbo.bs_news.treecode = dbo.bs_treemenu.treecode where dbo.bs_treemenu.treecode like '01.01%' and dbo.bs_treemenu.treecode='01.01.03' order by dbo.bs_news.id desc) Torder by dbo.bs_treemenu.treecode
select * from
(select top 1 dbo.bs_news.id, dbo.bs_news.title, dbo.bs_news.content, dbo.bs_treemenu.treename,dbo.bs_treemenu.treecode, dbo.bs_news.author, dbo.bs_news.addtime FROM dbo.bs_news INNER JOIN dbo.bs_treemenu ON dbo.bs_news.treecode = dbo.bs_treemenu.treecode where dbo.bs_treemenu.treecode like '01.01%' and dbo.bs_treemenu.treecode='01.01.03' order by dbo.bs_news.id desc) Torder by dbo.bs_treemenu.treecode