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