Skip to Content
0
Jan 10, 2023 at 07:18 PM

AYUDA NECESITO UNIR DOS CONSULTAS

39 Views

Buen dia.

tengo dos consultas unidas pero me arroja los resultados en líneas diferentes y necesito sea sobre la misma linea, me ayuda por favor.

de antemano gracias

adjunto código esta imagen es el resultado que me arroja la parte de stock es la que necesito este sobre la misma linea.

image.png

SELECT 
T1.[ItemCode] AS ARTICULO,
(sum(T1.[Quantity])) AS CANTIDAD,
(sum(T1.[DelivrdQty])) AS CANTENTREGADA,
(sum(T1.[OpenCreQty])) AS SALDO,
0 AS STOCK ,
T6.[MinLevel] AS MINIMO

FROM
ORDR T0
INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode
INNER JOIN OITW T4 ON T1.[ItemCode]=T4.[ItemCode]
INNER JOIN OCRD T5 ON T0.[CardCode] = T5.[CardCode]
INNER JOIN OITM T6 ON T1.[ItemCode] = T6.[ItemCode]
WHERE T1.[LineStatus] = 'O' AND T1.[WhsCode]=T4.[WhsCode]
group by T1.[ItemCode],
T6.[MinLevel]

UNION ALL


SELECT
TX.[ITEMCODE] AS ARTICULO,
0 AS CANTIDAD,
0 AS CANTENTREGADA,
0 AS SALDO,
STOCK= SUM(TX.[OnHand]) ,
0 AS MINIMO

FROM OITW TX WHERE TX.[WhsCode] in ('01','08','AT') GROUP BY TX.[ITEMCODE]

Attachments

image.png (5.1 kB)