18-09-21, 01:15 PM
سلام عليكم كيفية التعامل مع Views في sql sereve في هذا الكود أريد شرط ان الرصيد(Blance )يكون اقل من الحد(limite) يجلب بيانات الصنف علما بأن هذا هو الكود Sql
SELECT dbo.Balance.Num, dbo.Balance.Num_Product, dbo.Balance.Name_Product, dbo.Store.Num AS Expr1, dbo.Store.Name, dbo.Products.Last_PriceLY, dbo.Products.Selling_PriceLY, dbo.Products.WH_PriceLY,
dbo.Balance.Balance, dbo.Products.Limit
FROM dbo.Balance INNER JOIN
dbo.Products ON dbo.Balance.Num_Product = dbo.Products.Num_Product INNER JOIN
dbo.Store ON dbo.Balance.Store = dbo.Store.Num
SELECT dbo.Balance.Num, dbo.Balance.Num_Product, dbo.Balance.Name_Product, dbo.Store.Num AS Expr1, dbo.Store.Name, dbo.Products.Last_PriceLY, dbo.Products.Selling_PriceLY, dbo.Products.WH_PriceLY,
dbo.Balance.Balance, dbo.Products.Limit
FROM dbo.Balance INNER JOIN
dbo.Products ON dbo.Balance.Num_Product = dbo.Products.Num_Product INNER JOIN
dbo.Store ON dbo.Balance.Store = dbo.Store.Num