@liReza11800
یک شنبه 02 اسفند 1394, 08:29 صبح
با سلام
دستور زیر رو توی ویو میخوام ذخیره کنم خطا میده
اجرا میشه ولی خطا میده
کوئری :
SELECT dbo.Customers_TB.CustomerID, dbo.Customers_TB.InsertDate, dbo.Customers_TB.CategoryID, dbo.Customers_TB.AdsID, dbo.Customers_TB.MemberID, dbo.Customers_TB.FirstName AS 'نام مشتری',
dbo.Customers_TB.LastName, dbo.Customers_TB.Alias, dbo.Customers_TB.Description,
(SELECT TOP (1) FollowID
FROM dbo.Follows_TB
WHERE (dbo.Customers_TB.CustomerID = CustomerID)
ORDER BY FollowID DESC) AS LastComment
FROM dbo.Customers_TB LEFT OUTER JOIN
dbo.Follows_TB AS Follows_TB_1 ON dbo.Customers_TB.CustomerID = Follows_TB_1.CustomerID
خطا :
the order by clause is used only to determine the rows that are returned by the top clause ...
دستور زیر رو توی ویو میخوام ذخیره کنم خطا میده
اجرا میشه ولی خطا میده
کوئری :
SELECT dbo.Customers_TB.CustomerID, dbo.Customers_TB.InsertDate, dbo.Customers_TB.CategoryID, dbo.Customers_TB.AdsID, dbo.Customers_TB.MemberID, dbo.Customers_TB.FirstName AS 'نام مشتری',
dbo.Customers_TB.LastName, dbo.Customers_TB.Alias, dbo.Customers_TB.Description,
(SELECT TOP (1) FollowID
FROM dbo.Follows_TB
WHERE (dbo.Customers_TB.CustomerID = CustomerID)
ORDER BY FollowID DESC) AS LastComment
FROM dbo.Customers_TB LEFT OUTER JOIN
dbo.Follows_TB AS Follows_TB_1 ON dbo.Customers_TB.CustomerID = Follows_TB_1.CustomerID
خطا :
the order by clause is used only to determine the rows that are returned by the top clause ...