Seleccionar registros de dos tablas según criterio

[dashtrash]

Usa la misma técnica:

Código SQL:

SET @counter:=0;
INSERT INTO tablamaspeso 
SELECT [..campos..] FROM ( SELECT [..campos de empates..], @counter % 2 AS grupo, @counter:=@counter+1 FROM empates ) n WHERE grupo = 0;
SET @counter:=0;
INSERT INTO tablapezgrande 
SELECT [..campos..] FROM ( SELECT [..campos de empates..], @counter % 2 AS grupo, @counter:=@counter+1 FROM empates ) n WHERE grupo = 1;