【IT168 技术】在数据库中我运行了以下的查询语句:
#div_code img{border:0px;}<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--> Select PLAN_ID, EL_ID, NIIN, ITEM_NAME, PROJECT_CD,
CASE WHEN LCMC_DOC_NO IS NULL THEN MRODOC ELSE LCMC_DOC_NO END AS "DOCUMENT NUMBER "
FROM EQLIST_VIEW
WHERE PLAN_ID IN ( 736 , 1011 )
AND LCMC_DOC_NO IN ( ' W56HZV0327W501 ' , ' W52H090313X006 ' , ' W52H090314X026 ' ,
' W52H090314X027 ' , ' W52H090318X049 ' , ' W52H090320X003 ' , ' W56HZV0351M012 ' ,
' W56HZV0351M032 ' , ' W56HZV0351M035 ' , ' W919AD0334L091 ' , ' W919AD0334L092 ' ,
' W919AD0352L025 ' , ' W919AD0358L012 ' , ' W919AD0358L017 ' , ' W919AD0353L020 ' ,
' W56HZV0350M001 ' )
ORDER BY NIIN, “DOCUMENT NUMBER ”
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--> Select PLAN_ID, EL_ID, NIIN, ITEM_NAME, PROJECT_CD,
CASE WHEN LCMC_DOC_NO IS NULL THEN MRODOC ELSE LCMC_DOC_NO END AS "DOCUMENT NUMBER "
FROM EQLIST_VIEW
WHERE PLAN_ID IN ( 736 , 1011 )
AND LCMC_DOC_NO IN ( ' W56HZV0327W501 ' , ' W52H090313X006 ' , ' W52H090314X026 ' ,
' W52H090314X027 ' , ' W52H090318X049 ' , ' W52H090320X003 ' , ' W56HZV0351M012 ' ,
' W56HZV0351M032 ' , ' W56HZV0351M035 ' , ' W919AD0334L091 ' , ' W919AD0334L092 ' ,
' W919AD0352L025 ' , ' W919AD0358L012 ' , ' W919AD0358L017 ' , ' W919AD0353L020 ' ,
' W56HZV0350M001 ' )
ORDER BY NIIN, “DOCUMENT NUMBER ”
转载于:http://blog.itpub.net/24927532/viewspace-692567/