|
|
[ÀϹÝ] [sql] Äõ¸®¿¹Á¦ ÇѲ¨¹ø¿¡ updatet Çϱâ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 220.¢½.198.227 |
ÀÐÀ½:3552 |
|
|
$query=" UPDATE PDBSALETB A SET ACNT_YN = 'N'
WHERE A.PROD_CD = ( SELECT B.PROD_CD FROM SACNTTLTB B
WHERE B.DV_CD = A.DV_CD
AND B.DEAL_DAY = A.DEAL_DAY
AND B.PROD_CD = A.PROD_CD
AND B.ACNT_NUM = '$ACNT_NUM[$i]'
)
AND A.DV_CD = '$_Z[dv_cd]'
AND A.DEAL_DAY >= '$order_day1'
AND A.DEAL_DAY <= '$order_day2'
AND A.ACNT_YN = 'Y'
AND A.DEAL_CD ='$tmp_deal_cd'
";
|
|
|
220.¢½.198.227
|
|
|
06-03-10 00:10
|
|