Do you have spaces after the colons - i removed them below. PLus for the select sum I would include the selectdo and endselect.
select tdsls400.item, tccom100.bpid
from tdsls400, tccom100
where tdsls400.orno = tdsls400.orno
group by select tdsls400.item, tccom100.bpid
select sum (a.qoor):sum.qoor
from tdsls400 a, tccom100 b
where a.item = :tdsls400.item
and b.bpid = :tccom100.bpid
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
systems provided free by Baan Board
Play the Google game and help Baanboard get better rankings. Do your part. Click here
to find how.