SELECT t1.CUS_CODE
FROM fplus_customer t1
WHERE t1.CUS_CODE NOT IN (SELECT t2.CUS_CODE FROM value_for_12_mouth t2 WHERE t2.YEAR_ = '2025')
AND t1.CUS_NAME NOT LIKE '%**%' AND t1.CUS_CODE LIKE '%V%'
รายการร้านค้าที่มียอด ทั้งหมด 0 รายการ
SELECT cu.OKCUNO as cuno_,cu.OKCUNM as name_,cu.OKPHNO as phone_,cu.OKCFC6 as shop_type,
cu.OKCUA1+' '+cu.OKCUA2+''+cu.OKCUA3++cu.OKCUA4 as address_,pv.CKTX40 as province,cu.OKPONO as pcode,
cu.OKCFC9 as duo,cu.OKSDST as zone_,cu.OKCFC1 as area_,cu.OKCFC3 as route_,
0 as m1,
0 as m2,
0 as m3,
0 as m4,
0 as m5,
0 as m6,
0 as m7,
0 as m8,
0 as m9,
0 as m10,
0 as m11,
0 as m12,
'2025' as PERIOD
FROM MVXJDTA.OCUSMA AS cu
INNER JOIN MVXJDTA.CMNUSR AS cm ON cu.OKSMCD = cm.JUUSID AND cu.OKCONO = '410' AND cm.JUCONO = '410'
LEFT JOIN MVXJDTA.CSYSTS AS pv ON cu.OKECAR = pv.CKECAR AND pv.CKCONO = '410'
WHERE cu.OKCUCL in ('102','103') AND cu.OKCUNM NOT LIKE '**' AND cu.OKCUNO IN ()
GROUP By cu.OKCUNO,cu.OKCUNM,cu.OKCUA1,cu.OKCUA2,cu.OKCUA3,cu.OKCUA4,cu.OKPHNO,cu.OKSDST,cu.OKADID,cu.OKCUNO,cu.OKCFC3,cu.OKCFC9,cu.OKCFC6
,cu.OKCFC1,pv.CKTX40,cu.OKPONO
ORDER BY cu.OKCUNO
อัพเดท ข้อมูลร้านค้า ทั้งหมดจำนวน รายการ