[RESOLVED] Sub-select

[met0555]

Hi,

I will need a hint on how to write a mssql query.
I will like to run two SQL query as one query.

1) Select * from xxx where yyy=000 from zzzz
2) select user , sum(aaa+bbb) from xxx where hhh=4

i would like to run the second query on the result i will get from query 1. I'm not sure which function to use.

Thx

[abhijit]

Hello,
If you're still looking for responses, please post a script that will

a) Create necessary table structure.
b) Insert some data into these table structures.
c) Desired output from this data. How does the output look like?

[CVMichael]

Like this:

select user , sum(aaa+bbb)
from (Select * from xxx where yyy=000 from zzzz) AS www
where hhh=4

[met0555]

Hi,

it's giving me an error on the second from and as

SELECT user, sum((a,b))
group by user
from
(select * FROM xxxxkmain where net>0 ) as aaa

thx

[CVMichael]

The group by should be after the "from", like this:

SELECT user, sum((a,b))
from (select * FROM xxxxkmain where net>0 ) as aaa 
group by user

[met0555]

Thx, for the sample, my code is now working as expected