How can I 'LEFT OUTER JOIN' or 'LEFT JOIN' using Views in Drupal 7.
Here is what I'm trying to do, using an example from Wikipedia:
I have 2 content types: Employee's and Department's (tables below)
The "DepartmentID" noted in the Employee Table below in my case would be the NodeID of the department from the "Department" custom content type.
How can I use Drupal 7's Views module to Display a list of employees with the department name pulled from another content type as noted in the graphic below?
(The SQL statement below is really what I'm hoping to be able to do with the Views module, the table is the output I'm hoping to achieve.)