469,309 Members | 2,770 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,309 developers. It's quick & easy.

how to Mutiply different data type columns

8
Hi ,

I have the below tables

Table 1 with columns

id int
price char
quantity int
date date

In this table, same id has several entries at different date.

table 2 with columns

groupid int
groupname char


table 3 with columns

id int
groupid int


I want the result as

id
groupname
sum(quantity * price) for each id

Please help me in writing a query for this

Thanks in advance
Feb 29 '08 #1
1 1052
amitpatel66
2,367 Expert 2GB
Hi ,

I have the below tables

Table 1 with columns

id int
price char
quantity int
date date

In this table, same id has several entries at different date.

table 2 with columns

groupid int
groupname char


table 3 with columns

id int
groupid int


I want the result as

id
groupname
sum(quantity * price) for each id

Please help me in writing a query for this

Thanks in advance
Go ahead. Price will be internally converted to Integer and will get multiplied with Qty.
Feb 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Luis Esteban Valencia | last post: by
9 posts views Thread by Ben R. | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.