SQLite only supports INNER JOIN and LEFT JOIN. How do I do a FULL OUTER JOIN?
Yes. See the Join (SQL) > Outer join > Full outer join article on Wikipedia.
SELECT employee.*, department.*
FROM employee
LEFT JOIN department
ON employee.DepartmentID = department.DepartmentID
UNION ALL
SELECT employee.*, department.*
FROM department
LEFT JOIN employee
ON employee.DepartmentID = department.DepartmentID
WHERE employee.DepartmentID IS NULL