FULL OUTER JOIN with SQLite

by

Yes, see the example 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

More Related Contents:

  1. How can I do a FULL OUTER JOIN in MySQL?
  2. SQLite – How do you join tables from different databases?
  3. Select first row in each GROUP BY group?
  4. INNER JOIN ON vs WHERE clause
  5. SQL update from one Table to another based on a ID match
  6. Difference between JOIN and INNER JOIN
  7. How can I list the tables in a SQLite database file that was opened with ATTACH?
  8. Update table values from another table with the same user name
  9. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  10. SQL left join vs multiple tables on FROM line?
  11. SQL Joins Vs SQL Subqueries (Performance)?
  12. Delete column from SQLite table
  13. sqlite database default time value ‘now’
  14. Select random row(s) in SQLite
  15. basic recursive query on sqlite3?
  16. Record returned from function has columns concatenated
  17. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  18. Drop all tables command
  19. SQLite auto-increment non-primary key field
  20. PostgreSQL JOIN with array type with array elements order, how to implement?
  21. Core Data Performance with Single Parent Entity
  22. How to create timestamp column with default value ‘now’?
  23. String concatenation does not work in SQLite
  24. Unfindable SQLite Syntax Error
  25. SQL error: misuse of aggregate
  26. SQLite query, ‘LIKE’
  27. Join a count query on generate_series() and retrieve Null values as ‘0’
  28. UPSERT *not* INSERT or REPLACE
  29. Drop column from SQLite table
  30. converting int to real in sqlite

Leave a Comment