I am trying to populate an empty table(t) from another table(t2) based on a flag field being set. He is my attempt below and the table data.
UPDATE 2014PriceSheetIssues AS tJOIN TransSalesAvebyType2013Combined AS t2 SET t.`Tran_Type`=t2.`Tran_Type` WHERE t.`rflag`='1';Tran_Type; RetailAvePrice; WholesaleAvePrice; Rflag; Wflag;125C 992 650 1 \n2004R 1500 \N 1 \N4EAT 1480 1999 1 1
ليست هناك تعليقات:
إرسال تعليق