Hi!

If this subquery is used in a where clause (with =) or in a select statement like a column then the SUM must be applied to only one record. It seems that the query that you are using this in returns several rows from table a , b and x.

Can you post the complete query ?

Ramona