title: I am trying to find the sql query to get the red boxed items from the diagram. What is the query to get the red boxed columns?
body: <p><img src="https://i.stack.imgur.com/nCkrZ.jpg" alt="enter image description here" /></p>
  <p>I have been trying to the sql query for the columns in the red box, any assistance would be helpful.</p>
  <p>I tried this query:</p>
  <pre><code>SELECT
  
  Employees.LastName,
  
  Employees.FirstName,
  
  Region.RegionDescription
  
  FROM
  
      (
      
          (
      
              (Employees 
      
                  LEFT JOIN
      
                  EmployeeTerritories 
      
                      ON Employees.EmployeeID = EmployeeTerritories.EmployeeID) 
      
          LEFT JOIN
      
          Territories 
      
              ON EmployeeTerritories.EmployeeID = Territories.TerritoryID) 
      
      LEFT JOIN
      
        Region 
      
          ON Territories.RegionID = Region.RegionID
      
      ); 
  </code></pre>