Search posts...
SELECT PT_NAME, PT_NO, GEND_CD, AGE, if (TLNO is null, "NONE", TLNO) TLNO FROM PATIENT where age <= 12 and GEND_CD = "W" ORDER BY AGE desc, PT_NAME asc;
gunwoo