1. Provide an example of a multi-table join. Present the SQL Server code and describe its purpose.
When would it be appropriate to use?
The example can be one you develop from scratch, use at your employment, or have located from some other source. However, the code must be in Microsoft SQL server; please do not reference other DBMS Software. If you cite an example from another source, please list your reference.