DECLARE @Valid_ID INT
SELECT @Valid_ID= Vila_Id
FROM dbo.Vila
WHERE (ID = '5')
SELECT @Valid_ID Valid_Id, S3.*,S3.Price+IsNull(S3.Haml_Price,0)+ISNULL(S3.al l_price,0)
- ISNULL(s3.takhfif,0) jam
FROM (
SELECT S1.*,IsNull(S2.Price,0) Price FROM (
SELECT R.*,S.[name] FROM (
SELECT P.*,Q.shop_name FROM (
SELECT * FROM Factor_Master)P
LEFT OUTER JOIN
(SELECT * FROM shop)Q
ON P.factor_shop=Q.id)R
LEFT OUTER JOIN
(SELECT * FROM fact_type)S
ON R.typ=S.id)S1
LEFT OUTER JOIN
(SELECT Fact_ID,SUM(Cast(Price AS INT)) Price FROM Factor_Slave
GROUP BY Fact_ID)S2
ON S1.ID=S2.Fact_ID)S3