Hi all I am having trouble with this update command. It looks like it should work but I can't see what is wrong.
I know I could do this with a temp tab or view but want to try to do it in one command. Update inslogb set OvperClm = select (count(distinct tr_date)) + from tran_hist where tr_type = 1 group by custnum,blddate + >From inslogb T1. tran_hist T2 where T1.custnum = T2.custnum + and T1.billdate = T2.blddate I also tried moving the ( ) around the select statement, the select statement works by itself. thanks for any help Marc
