CapTech interview question

How do you merge two tables in Python or SQL?