SELECT DISTINCT ID ,n.*
p.ImageServerFile AS Expr1
FROM News n LEFT OUTER JOIN
pic p ON n.NewsID = p.NewsID
WHERE (n.Publish = 'one ') AND (n.NewscatalogID = 7 )
ORDER BY YEAR(n.NewsDate), MONTH(n.NewsDate), DAY(n.NewsDate) DESC
------解决方案--------------------
up