使用SQLite进行完全外部联接 [英] FULL OUTER JOIN with SQLite
本文介绍了使用SQLite进行完全外部联接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SQLite仅具有INNER和LEFT JOIN.
SQLite only has INNER and LEFT JOIN.
是否可以使用SQLite进行完全外部联接?
Is there a way to do a FULL OUTER JOIN with SQLite?
推荐答案
是的,请参见维基百科.
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
这篇关于使用SQLite进行完全外部联接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文