Hi All,

I can't seem to get this to work, although the subquery performs if used by itself, is it due to the calculation occuring??


****this gets me an "subquery is invalid" error message
select ownpct.comp_no from ownpct where ownpct.comp_no in (select ownpct.comp_no, sum(ownpct.pct) as pctsum from ownpct group by comp_no having pctsum <> 100)
***end of select

I could run two selects but I though it'd be neater to get it done in one.

Please let me know if or what I'm doing wrong.

TIA

Jim Harvey