using等价于join操作中的on
using自连接挺好用
SELECT
a.dept_id,
b.dept_id
FROM
sys_dept a
JOIN sys_dept b USING (dept_id,parent_id)
SELECT
a.dept_id,
b.dept_id
FROM
sys_dept a
LEFT JOIN sys_dept b
ON a.dept_id=b.dept_id and a.parent_id=b.parent_id
using等价于join操作中的on
using自连接挺好用
SELECT
a.dept_id,
b.dept_id
FROM
sys_dept a
JOIN sys_dept b USING (dept_id,parent_id)
SELECT
a.dept_id,
b.dept_id
FROM
sys_dept a
LEFT JOIN sys_dept b
ON a.dept_id=b.dept_id and a.parent_id=b.parent_id