on 07-16-2013 1:37 PM
Bom dia Pessoal,
Gostaria de fazer a união das tabelas abaixo para formatar uma consulta, não sei se é possível, se caso for alguém pode ajudar?
--NF SAIDA
SELECT
T0.[DocNum],
T0.[Serial],
T0.[TaxDate],
T0.[CardCode],
T0.[CardName],
T0.[DocTotal],
T0.[U_informacao]
FROM OINV T0
WHERE T0.[Serial] >= 500
AND T0.[SeqCode] = 29
ORDER BY T0.[Serial] DESC
--ENTREGA
SELECT
T0.[DocNum],
T0.[Serial],
T0.[TaxDate],
T0.[CardCode],
T0.[CardName],
T0.[DocTotal],
T0.[U_informacao]
FROM ODLN T0
WHERE T0.[Serial] >= 500
AND T0.[SeqCode] = 29
ORDER BY T0.[Serial] DESC
--DEV. NF ENTRADA
SELECT
T0.[DocNum],
T0.[Serial],
T0.[TaxDate],
T0.[CardCode],
T0.[CardName],
T0.[DocTotal],
T0.[U_informacao]
FROM ORPC T0
WHERE T0.[Serial] >= 500
AND T0.[SeqCode] = 29
ORDER BY T0.[Serial] DESC
--RECEPÇAO
SELECT
T0.[DocNum],
T0.[Serial],
T0.[TaxDate],
T0.[CardCode],
T0.[CardName],
T0.[DocTotal],
T0.[U_informacao]
FROM OPDN T0
WHERE T0.[Serial] >= 500
AND T0.[SeqCode] = 29
ORDER BY T0.[Serial] DESC
Bom dia Evanildo,
Para unir os resultados das consultas, você deve utilizar o comando "Union All" entre as consultas e também utilizar o comando "order by" somente no final da ultima consulta.
Fiz os testes aqui e deu tudo certo!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
12 | |
11 | |
6 | |
6 | |
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.