Fórum Query com duas tabelas #28900

SELECT DISTINCT(C5.C5_NUM)    AS PEDIDO, C5.C5_TIPO    AS TIPO,
                C5.C5_CLIENTE AS CLIENTE,
        TO_DATE(C5.C5_EMISSAO, ´YYYY/MM/DD´)           AS EMISSAO,
                C5.C5_VEND1   AS VEND1,  C5.C5_VEND2   AS VEND2,
                C5.C5_LIBEROK AS OK,     C5.C5_NOTA    AS NOTA_P,
                C5.C5_SERIE   AS SERIE,  D2.D2_DOC     AS NOTA_C,
                D2.D2_SERIE   AS SERIE,  C5.C5_EMISSAO AS DATA
FROM PEDIDO C5 INNER JOIN ITENS D2 ON
(
 D2.D_E_L_E_T_ <> ´*´           AND
 D2.D2_EMISSAO = C5.C5_EMISSAO  AND
 D2.D2_CLIENTE = C5.C5_CLIENTE  AND
 D2.D2_FILIAL  = C5.C5_FILIAL   AND
 D2.D2_PEDIDO  = C5.C5_NUM
)
WHERE
 C5.D_E_L_E_T_ <> ´*´       AND
 C5.C5_EMISSAO = ´20071109´ AND
 C5.C5_FILIAL  = ´01´;

SELECT DISTINCT(C5_NUM) AS PEDIDO, C5_TIPO AS TIPO, C5_CLIENTE AS CLIENTE,  
      TO_DATE(C5_EMISSAO, ´YYYY/MM/DD´) AS EMISSAO, 
      C5_VEND1 AS VEND1, C5_VEND2 AS VEND2, C5_LIBEROK AS OK, 
      C5_NOTA AS NOTA, C5_SERIE AS SERIE, C5_EMISSAO AS DATA 
      FROM PEDIDO C5 
      WHERE 
       C5_FILIAL   =  ´01´          AND 
       C5_EMISSAO  =  ´20071109´    AND
       D_E_L_E_T_ <> ´*´
      ORDER BY C5_EMISSAO ASC;