SELECT '1050', BIS_PART, BIS_STORE, BIS_BIN, SUM(BIS_QTY), '全盘'
FROM
(SELECT * FROM
(SELECT STO_PART, STO_STORE
FROM REPAIR_STOCK
WHERE STO_QTY <> 0
AND STO_STORE = '2'
ORDER BY DBMS_RANDOM.RANDOM)
WHERE ROWNUM < 5) PAR,
REPAIR_BINSTOCK
WHERE STO_STORE = BIS_STORE
AND STO_PART = BIS_PART
AND BIS_QTY <> 0
GROUP BY BIS_PART, BIS_STORE, BIS_BIN如题...
FROM
(SELECT * FROM
(SELECT STO_PART, STO_STORE
FROM REPAIR_STOCK
WHERE STO_QTY <> 0
AND STO_STORE = '2'
ORDER BY DBMS_RANDOM.RANDOM)
WHERE ROWNUM < 5) PAR,
REPAIR_BINSTOCK
WHERE STO_STORE = BIS_STORE
AND STO_PART = BIS_PART
AND BIS_QTY <> 0
GROUP BY BIS_PART, BIS_STORE, BIS_BIN如题...
SQL> SELECT *
2 FROM (SELECT 'CSDN-ORACLE' MYSTR FROM DUAL)TT;MYSTR
-----------
CSDN-ORACLE
为子查询起一个别名select * from
(
select sysdate form dual
) par