I have a database named newbase and columns are
1. Itid
2. Itname
3. Itprice
4. Itquantity
I get the sum of the price using itname and the query is

select SUM(itprice)as total from trick where itname=’a’

I got the result but now problem is that I want to get other columns data with some addition in the query on the form
I am developing a win application vb.net 2005 and sql server 2000 tools I am using can any one make the query

What exactly do you want in new query?

What exactly do you want in new query?

More elaboration what I want
Trick
Itid itname itprice itquantity
1 a 5 6
2 a 4 3
4 p 8 3
Query
select SUM(itprice)as total from trick where itname='a'
result
10
I want the full to display in data grid and for that I need query ok
Like
Itid itname itprice itquantity total
1 a 5 6 10
2 a 4 3


just i want is query thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.