这个sql为什么错误亚SELECTDISTINCTID,n.*p.ImageServerFileASExpr1FROMNewsnLEFTOUTERJOINpicpONn.NewsID
这个sql为什么错误亚
SELECT DISTINCTID ,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