INSERT INTO Orders ( userid, timestamp) SELECT Orders.userid, Orders.timestamp FROM Users INNER JOIN Orders ON Orders.id = Users.id