Re: combining 2 tables

[Rick James]

INSERT INTO new (...)
SELECT ...
FROM t1
JOIN t2 ON t1.a = t2.a AND t1.b = t2.b AND t1.c = t2.c

This assumes the tables t1 and t2 are fully in a 1:1 relationship on those 3 columns (a,b,c). If not, you may need LEFT JOIN or some other technique.