AYUDA NECESITO UNIR DOS CONSULTAS

[jhonattan_cedillo]

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.

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]

[LoHa · Accepted solution]

Hi Jhonattan,

try this

SELECT 
T1.[ItemCode] AS ARTICULO,
(sum(T1.[Quantity])) AS CANTIDAD, 
(sum(T1.[DelivrdQty])) AS CANTENTREGADA,
(sum(T1.[OpenCreQty])) AS SALDO,
(SELECT SUM(TX.[OnHand]) FROM OITW TX WHERE  TX.[WhsCode] in ('01','08','AT') AND TX.[ItemCode] = T1.[ItemCode]) 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]

regards Lother

[jhonattan_cedillo · Accepted solution]

gracias justo lo que necesitaba