แก้ APP2108 ตรวจแฟ้ม Appointment ค่าไม่ตรงมาตรฐาน

แก้ APP2108   ตรวจแฟ้ม Appointment ค่าไม่ตรงมาตรฐาน

ไม่มีอะไรมากครับ เอา sql ไปรันดูครับ

SELECT

*

FROM

oapp

WHERE

provis_aptype_code NOT IN (

"010",

"011",

"021",

"022",

"023",

"024",

"031",

"032",

"033",

"034",

"035",

"041",

"042",

"043",

"051",

"052",

"053",

"061",

"072",

"073",

"081",

"082",

"083",

"084",

"085",

"086",

"087",

"088",

"089",

"091",

"092",

"093",

"101",

"102",

"103",

"104",

"105",

"106",

"107",

"108",

"109",

"110",

"111",

"112",

"113",

"114",

"115",

"121",

"131",

"141",

"151",

"161",

"171",

"181",

"201",

"202",

"203",

"204",

"205",

"815",

"816",

"901",

"C11",

"C12",

"C13",

"C14",

"D11",

"D12",

"D13",

"D14",

"D21",

"D22",

"D23",

"D24",

"D31",

"D32",

"D33",

"D34",

"D35",

"D41",

"D42",

"D43",

"D44",

"D45",

"D51",

"D52",

"D53",

"D54",

"D55",

"H11",

"H12",

"H13",

"H14",

"H21",

"H22",

"H31",

"H32",

"H33",

"H41",

"H42",

"H43",

"I11",

"I12",

"I13",

"I14",

"I15",

"J11",

"J12",

"M11",

"M12",

"M21",

"M31",

"P11",

"P12",

"P13",

"P14",

"P21",

"P22",

"P23",

"P24",

"P31",

"P32",

"R11",

"R12",

"R21",

"R22",

"R23",

"T11",

"T12",

"T21",

"T31",

"T32",

"T33",

"T41",

"V11",

"V12",

"Y11"

)

LIMIT 100