//mysql
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '',
  database: 'excel'
});

//test conection
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected!n');
});

//count of remitos
var numrtos;
var gcrtoqy = 'SELECT COUNT(*) FROM rto;';
connection.query(gcrtoqy, (err, cb) => {
  if(err) throw err;
  numrtos = cb[0];
  numrtos = Object.values(numrtos)[0]
  console.log('CANT Remitos:', numrtos);
});

//
setTimeout(function(){
  console.log('nData:n');
  for (let i = 1; i <= numrtos; i++) {
    var fullqy = 'SELECT r.fecha, r.importe, v.fecha, v.importe FROM vta v INNER JOIN rto r ON r.id = '+i+' WHERE v.fecha >= r.fecha AND v.importe = r.importe LIMIT 1;';
    connection.query(fullqy, (err,match) => {
      if(err) throw err;
      console.log(match);
    });
  }
}, 500);

Connected!

CANT Remitos: 3
CANT Ventas: 5

Data:

[ RowDataPacket { fecha: 2016-01-01T03:00:00.000Z, importe: 99 } ]
[ RowDataPacket { fecha: 2016-01-01T03:00:00.000Z, importe: 99 } ]
[ RowDataPacket { fecha: 2016-01-01T03:00:00.000Z, importe: 99 } ]

DROP PROCEDURE IF EXISTS ROWPERROW;
DELIMITER ;;

CREATE PROCEDURE ROWPERROW()
BEGIN
DECLARE n INT DEFAULT 0;
DECLARE i INT DEFAULT 0;
SELECT COUNT(*) FROM rto INTO n;
SET i=1;
WHILE i<=n DO

 CREATE TABLE BigTable AS
  SELECT r.fecha, r.importe, v.fecha, v.importe
    FROM vta v
    INNER JOIN rto r
    ON r.id = i
    WHERE v.fecha >= r.fecha AND v.importe = r.importe
    LIMIT 1;

  SET i = i + 1;
END WHILE;
End;
;;