Sorry, that's a type, I do not have that on my code. Marc
----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, August 22, 2005 9:55 AM Subject: [RBG7-L] - RE: update command > Marc: > >>>>> > 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 > <<<<< > A quick look indicates that you have a period (.) too many after T1 on the > third line... > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Marc > Sent: Monday, August 22, 2005 9:11 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - update command > > 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 > >
