on 10-11-2017 4:13 PM
Hola como están, tengo dos consultas y quisiera unirlas para que se muestren en dos columnas diferentes, la base es hana, podrian ayudarme?
Consulta 1:
SELECT T2."TrnspName" as "Transportista", COUNT (T1."ItemCode" ) as "Lineas Fact", sum (case when T1."U_HORMAS" IS NULL OR T1."U_HORMAS"=0 Then T1."Quantity" else T1."U_HORMAS" END) AS "Bultos Fact" FROM OINV T0 INNER JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry" INNER JOIN OSHP T2 ON T0."TrnspCode" = T2."TrnspCode" WHERE T0."DocDate" between [%0] and [%1] GROUP BY T2."TrnspName"
Consulta 2:
SELECT T2."TrnspName" as "Transportista", -COUNT (T1."ItemCode" ) as "Lineas Nc", - sum (case when T1."U_HORMAS" IS NULL OR T1."U_HORMAS"=0 Then T1."Quantity" else T1."U_HORMAS" END) AS "Bultos Nc" FROM ORIN T0 INNER JOIN RIN1 T1 ON T0."DocEntry" = T1."DocEntry" INNER JOIN OSHP T2 ON T0."TrnspCode" = T2."TrnspCode" WHERE T0."DocDate" between [%0] and [%1] AND T1."U_MOTIVO_DEVOLUCION"=9 GROUP BY T2."TrnspName"
La consulta final que quiero realizar es:
Transportista, Lineas Fact, Bultos Fact, Lineas Nc, Bultos Nc
Gracias
Hola
entre las dos sentencias SQL debes poner UNION ALL:
Sentencia SQL1
UNION ALL
Sentencia SQL2
Recuerda que el número de campos de ambas sentencias debe ser el mismo, el tipo de campo también, y los alias.
Un saludo
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola
yo lo plantearía así:
SELECT lainformaciónquenecesites FROM
(
SELECT loscamposdeconsulta FROM
(tuprimeraconsulta S0 LEFT JOIN tusegundaconsulta S1 ON S0.transportista = S1.transportista)
UNION ALL
SELECT loscamposdeconsulta FROM
(tuprimeraconsulta S2 RIGHT JOIN tusegundaconsulta S3 ON S2.transportista = S3.transportista)) R0
group by R0.transportista
Un saludo
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.