UPDATE ap_inv a SET tot_1= tot_1 + (select inv_tot_amount from vn_inv v (Select v.inv_num, v.po_num from vn_inv v where a.inv_num=v.inv_num AND a.po_num=v.po_num));
Comma missing.Code:UPDATE ap_inv a SET tot_1= tot_1 + (select inv_tot_amount from vn_inv v, (Select v.inv_num, v.po_num from vn_inv v where a.inv_num=v.inv_num AND a.po_num=v.po_num ) );
Tamil




Reply With Quote