[JXJ]

super.. muchas gracias a ambos. olbeup y guillotmarc.

areglada la aquery sale asi.

Código SQL [-]
SELECT
     PEDI.ID 
    ,PEDI.RFC_PERTENECE_EMPRESA  
    ,PEDI.CODIGO AS CODIGOPEDI  
    ,PEDI.UCODADUANA ,PEDI.PEDIMENTONUM
    ,PEDI.PEDIMENTOFECHA
    ,PEDI.STATUS
    ,ADU.ADUANA
    ,ADU.CODIGO AS CODIGOADU
    ,ADU.STATUS
  FROM Pedimentos AS PEDI 
      INNER JOIN Aduanas AS ADU
      ON ADU.CODIGO = PEDI.UCODADUANA
  WHERE PEDI.RFC_PERTENECE_EMPRESA = 'NWM9709244W4'
        AND PEDI.CODIGO = 'NWMPEDIMENTOS0003'