Hi,
 
Required result is as follows:
 
Book_Name   Book_Price   Copy_Sold
ABC               1250.00          1130
LMN               5698.00          240
PQR               1524.00          1972
 
 
 
Thanks.
 
Vishal

 

--- On Tue, 14/9/10, Aurimas Černius <aurimas@...> wrote:


From: Aurimas Černius <aurimas@...>
Subject: Re: [firebird-support] Doubt Regarding Sum() Function
To: firebird-support@yahoogroups.com
Date: Tuesday, 14 September, 2010, 6:06 PM


 



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









[Non-text portions of this message have been removed]