兩條SQL陳述句都可以查詢
SELECT [單據型別] ,[單據號],
(CASE WHEN [倉庫]=‘10’ then ‘原料倉’
when [倉庫]=‘20’ then ‘半成品倉’
when [倉庫]=‘30’ then ‘成品倉’
when [倉庫]=‘40’ then ‘產線不良倉’
when [倉庫]=‘50’ then ‘研發倉’
when [倉庫]=‘60’ then ‘車間倉’
when [倉庫]=‘70’ then ‘來料不良’
when [倉庫]=‘80’ then ‘返修良品’
when [倉庫]=‘81’ then ‘返修不良’
when [倉庫]=‘90’ then ‘售后倉’
when [倉庫]=‘91’ then ‘銷售服務倉’ END) as [倉庫] ,
(CASE WHEN [收發類別]=‘202’ THEN ‘普通銷售出庫’
WHEN [收發類別]=‘203’ THEN ‘委外發料’
WHEN [收發類別]=‘204’ THEN ‘調撥出庫’
WHEN [收發類別]=‘205’ THEN ‘委外發料’
WHEN [收發類別]=‘206’ THEN ‘生產補料’
WHEN [收發類別]=‘207’ THEN ‘輔料領用’
WHEN [收發類別]=‘208’ THEN ‘研發領料’
WHEN [收發類別]=‘209’ THEN ‘委外補料’
WHEN [收發類別]=‘210’ THEN ‘部門領料’
WHEN [收發類別]=‘211’ THEN ‘借出領料’
WHEN [收發類別]=‘212’ THEN ‘客供料出庫’
WHEN [收發類別]=‘213’ THEN ‘售后領料’
WHEN [收發類別]=‘298’ THEN ‘其他出庫’
WHEN [收發類別]=‘299’ THEN ‘報廢出庫’
END) as [收發類別] ,
[存貨編碼] ,[數量], [累計出庫輔計量數量],[實際數量], [代管結算數量], [應收應發數量], [日期], [部門], [制單人] ,[制單日期] FROM
(SELECT cBusType as [單據型別] ,cCode as [單據號], cWhCode AS [倉庫],cRdCode AS [收發類別], cInvCode AS [存貨編碼] , iQuantity AS [數量],iSOutNum AS [累計出庫輔計量數量],iFQuantity[實際數量], iVMISettleQuantity [代管結算數量],iNQuantity [應收應發數量], dDate AS [日期], cDepCode AS [部門],cMaker AS [制單人] ,dnmaketime AS [制單日期] FROM RdRecordS08 RS8 INNER JOIN rdrecord08 R8 ON RS8.ID=R8.ID
UNION
SELECT cBusType as [單據型別] ,cCode as [單據號], cWhCode AS [倉庫],cRdCode AS [收發類別], cInvCode AS [存貨編碼] , iQuantity AS [數量],iSOutNum AS [累計出庫輔計量數量],iFQuantity[實際數量], iVMISettleQuantity [代管結算數量],iNQuantity [應收應發數量], dDate AS [日期], cDepCode AS [部門],cMaker AS [制單人] ,dnmaketime AS [制單日期] FROM rdrecords09 RS9 INNER JOIN RdRecord09 R9 ON RS9.ID=R9.ID
UNION
2、出入庫明細
SELECT cBusType as [單據型別] ,cCode as [單據號], cWhCode AS [倉庫],cRdCode AS [收發類別], cInvCode AS [存貨編碼] , iQuantity AS [數量],iSOutNum AS [累計出庫輔計量數量],iFQuantity[實際數量], iVMISettleQuantity [代管結算數量],iNQuantity [應收應發數量], dDate AS [日期], cDepCode AS [部門],cMaker AS [制單人] ,dnmaketime AS [制單日期] FROM rdrecords10 RS10 INNER JOIN rdrecord10 R10 ON RS10.ID=R10.ID
UNION
SELECT cBusType as [單據型別] ,cCode as [單據號], cWhCode AS [倉庫],cRdCode AS [收發類別], cInvCode AS [存貨編碼] , iQuantity AS [數量],iSOutNum AS [累計出庫輔計量數量],iFQuantity[實際數量], iVMISettleQuantity [代管結算數量],iNQuantity [應收應發數量], dDate AS [日期], cDepCode AS [部門],cMaker AS [制單人] ,dnmaketime AS [制單日期] FROM RdRecordS11 RS11 INNER JOIN rdrecord11 R11 ON RS11.ID=R11.ID
UNION
SELECT cBusType as [單據型別] ,cCode as [單據號], cWhCode AS [倉庫],cRdCode AS [收發類別], cInvCode AS [存貨編碼] , iQuantity AS [數量],iSOutNum AS [累計出庫輔計量數量],iFQuantity[實際數量], iVMISettleQuantity [代管結算數量],iNQuantity [應收應發數量], dDate AS [日期], cDepCode AS [部門],cMaker AS [制單人] ,dnmaketime AS [制單日期] FROM rdrecords01 RS01 INNER JOIN rdrecord01 R01 ON RS01.ID=R01.ID )
AS T
WHERE 存貨編碼 =‘3008040100’
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/278929.html
標籤：其他
上一篇：ACCESS常見錯誤場景
下一篇：Oracle進階（二）存盤程序