BIB_LIMIT.BIB_NO,BIB_LIMIT.CALLNO,V_SUT_BIBTAG910.BIB_NO,V_SUT_BIBTAG910.TITLE,V_SUT_BIBTAG910.AUTHOR,V_SUT_BIBTAG910.STD_NO,V_SUT_BIBTAG910.EDITION,V_SUT_BIBTAG910.PUB_YEAR,V_SUT_BIBTAG910.TAG910,V_SUT_BIBTAG910.ITEM_CNT


select rownum,V_SUT_BIBTAG910.BIB_NO,V_SUT_BIBTAG910.TITLE,V_SUT_BIBTAG910.AUTHOR,BIB_LIMIT.CALLNO,V_SUT_BIBTAG910.STD_NO,V_SUT_BIBTAG910.EDITION,
V_SUT_BIBTAG910.PUB_YEAR, V_SUT_BIBTAG910.LANG_CODE, V_SUT_BIBTAG910.GMD, V_SUT_BIBTAG910.TAG910,V_SUT_BIBTAG910.ITEM_CNT 
from V_SUT_BIBTAG910 , BIB_LIMIT where 1=1 AND BIB_LIMIT.BIB_NO = V_SUT_BIBTAG910.BIB_NO

and V_SUT_BIBTAG910.TAG910 like '%Nursing%'
--and V_SUT_BIBTAG910.GMD like '[%'

--ในกรณีทีไม่ต้องการให้แสดง GMD ให้ใส่เครื่องหมาย -- หน้าบรรทัดนั้นที่ 2 
--ตัวอย่าง --and V_SUT_BIBTAG910.GMD like '[%'