haquocquan > 13-06-11, 12:07 AM
UPDATE Su_Dung INNER JOIN Chi_Tiet ON Su_Dung.Ma_SD = Chi_Tiet.Ma_SD SET Chi_Tiet.Thanh_Tien = IIf([So_Kw]<100,[Don_Gia]*[So_Kw],IIf([So_Kw]<=200,[Don_Gia]*100+([So_Kw]-100)*[Don_Gia]*1.5,[Don_Gia]*100+100*[Don_Gia]*1.5+([So_Kw]-200)*[Don_Gia]*2));