fakhravari
دوشنبه 07 آذر 1390, 01:29 صبح
با سلام
SELECT TOP (2) NewsID, Title, Abstract, Contents, AddDate, img,
(SELECT COUNT(1) AS CountOfPostID
FROM Comments
WHERE (PostID = TBLNews.NewsID)) AS Comments,
(SELECT SUM(Rating) AS SumOfRating
FROM RatingPost
WHERE (PostID = TBLNews.NewsID)) AS Rates,
(SELECT COUNT(1) AS CountOfID
FROM RatingPost AS RatingPost_1
WHERE (PostID = TBLNews.NewsID)) AS Rates
FROM TBLNews
ORDER BY NewsID DESC
اما قسمت های COUNT(1) AS CountOfPostID و SUM(Rating) AS SumOfRating و COUNT(1) AS CountOfID در برنامه نویسی به مقدار های as آنها دسترسی ندارم.
دوستان به چه شکل عمل کنم:متفکر:
SELECT TOP (2) NewsID, Title, Abstract, Contents, AddDate, img,
(SELECT COUNT(1) AS CountOfPostID
FROM Comments
WHERE (PostID = TBLNews.NewsID)) AS Comments,
(SELECT SUM(Rating) AS SumOfRating
FROM RatingPost
WHERE (PostID = TBLNews.NewsID)) AS Rates,
(SELECT COUNT(1) AS CountOfID
FROM RatingPost AS RatingPost_1
WHERE (PostID = TBLNews.NewsID)) AS Rates
FROM TBLNews
ORDER BY NewsID DESC
اما قسمت های COUNT(1) AS CountOfPostID و SUM(Rating) AS SumOfRating و COUNT(1) AS CountOfID در برنامه نویسی به مقدار های as آنها دسترسی ندارم.
دوستان به چه شکل عمل کنم:متفکر: