nexted query not working

[hyy1109]

I have the following nested query. The second select sum(amount) works by itself. But, the whole query not working. Please help. Thanks.

SELECT *
FROM (select sum(amount) amount, leaseid, accntyearmonth, loscode from leaselos where specialtype='Net' group by leaseid, loscode,accntyearmonth )

 

[rac2]

The subquery may need an alias.

SELECT *
  FROM (select sum(amount) amount, leaseid, accntyearmonth, loscode from leaselos  where  specialtype='Net' group by leaseid, loscode,accntyearmonth ) aNameForTheSubquery

For future reference and with more difficult problems, you may wish to post the error message such as

Incorrect syntax near ')'

"It doesnt work" doesnt give us much to go on.

 

[hyy1109]

yes, Incorrect syntax near ')'. Now it is working like a charm after adding an alias. Thanks!