FDM Group interview question

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