Exemplo: FIRST 1

SELECT FIRST 1 P.NumPedCli,
               IP.NItemPED
          FROM NotaPed AS N
    INNER JOIN Pedidos AS P
            ON P.Abrev = N.Abrev
           AND P.Modelo = N.ModeloPed
           AND P.NumPedido = N.NumPedido
    INNER JOIN ItensPe AS IP
            ON IP.Abrev = P.Abrev
           AND IP.Modelo = P.Modelo
           AND IP.NumPedido = P.NumPedido
           AND IP.Item = N.ItemPedido
         WHERE N.Abrev = :PAbrev
           AND N.ModeloNF = :PModeloNF
           AND N.NumLancto = :PNumLancto
           AND N.ItemNF = :PItemNF