i.e. it should give sum of asset values in case the relevant factor falls between start and end range.

I am not sure how can I get results in such data set as UNION, CROSS JOIN,INNER JOIN are not working. Either I am getting repaeted entires or error messages. Please help. I have used this query SELECT A.Start_Range, A.End_Range, SUM(B.asset) AS Sum_Asset FROM dbo.Graph_Range AS A , dbo.Graph_Data AS B GROUP BY A.Start_Range, A.End_Range , b.Factor HAVING (B.Factor < A.End_Range) AND (B.Factor > A.Start_Range)

SELECT g.Start_Range AS Lower_Limit,
g.End_Range AS Upper_limit,
COALESCE(d.SumAsset,0) AS Sum_Asset
FROM Graph_Range g
OUTER APPLY (SELECT SUM(Asset) AS Sum_Asset
FROM Graph_data
WHERE factor BETWEEN g.Start_Range AND g.End_Range
)d