[RBG7-L] - Re: UPDATE syntax

[Lawrence Lustig]

Try:

 UPDATE TABLE +
   SET billing_amt = (da_fee + t2.adjusted_total) +
   FROM d_b_allocation t1, d_invoice_header t2 +
   WHERE t1.invoice_id = t2.invoice_id AND da_invoice_dt = 12/20/04

Don't qualify the T1 fields before the FROM statement with T1.
--
Larry