Hi,

> Select BM.Book_Name, Max(BM.Book_Price), ...
> this would not give me the sum.
>
> i am talking about the feature case where i need to have multiple records exist in two tables and I need to have sum of respective column from respective table only.

Please, provide the sample data and a result, you want to get for that
data. This will make it easier for us to understand, what is the desired
result.

--
Aurimas