Join (SQL)
Unlike the inner join, Williams is printed in the final result, even though Williams did not have a department ID.  Because Employee was the left table, or the table first mentioned in the SQL query, SQL returns all of the relevant data needed from it.  However, since there was not a department ID for Williams, the Department table was only able to return a null result.