INSERT INTO calculationsall (
id,
configuration,
label,
entry_id,
path,
composition_id,
natoms,
input_id,
settings,
output_id,
energy,
energy_pa,
magmom,
magmom_pa,
dos_id,
band_gap,
irreducible_kpoints,
attempt,
nsteps,
converged,
runtime
) SELECT
b.id,
b.configuration,
b.label,
b.entry_id,
b.path,
b.composition_id,
b.natoms,
b.input_id,
b.settings,
b.output_id,
b.energy,
b.energy_pa,
b.magmom,
b.magmom_pa,
b.dos_id,
b.band_gap,
b.irreducible_kpoints,
b.attempt,
b.nsteps,
b.converged,
b.runtime
FROM
( SELECT * FROM calculations2 UNION SELECT * FROM calculations3 ) AS b