FDM Group Interview Question

How do you join SQL tables and what is it used for ?