الخميس، 26 ديسمبر 2013

Populate values from one table

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

View the original article here

ليست هناك تعليقات:

إرسال تعليق