Provide
an example of a multi-table join. 2 Part Question

Present the SQL
Server code and describe its purpose. When would it be appropriate
to use? The example can be one you develop from scratc