Skip to content

Instantly share code, notes, and snippets.

SELECT *
FROM(
SELECT DISTINCT
D2_FILIAL AS [FILIAL],
D2_PEDIDO AS [PEDIDO],
C5_EMISSAO AS [EMISSAO_PEDIDO],
D2_DOC AS [NOTA],
D2_EMISSAO AS [EMISSAO_NOTA],
D2_E_INC AS [FLAG_INCLUSAO],
D2_E_DEL AS [FLAG_DELECAO],