How to copy data from one table to another (where both have other fields too that are not in common)?

INSERT INTO Destination SELECT * FROM Source;

See SQL As Understood By SQLite: INSERT for a formal definition.