获取字符串'marketing'的 NULL 值，并且 'makeing' as soundex 仅删除元音，因为两者具有相同的 soundex 字符串值

Question

编写一个查询，从Emp Master表中返回部门拼写错误的员工id列表。正确的数据在没有外键的Dept_Master中。

SELECT * FROM Emp_Master as orig
LEFT OUTER JOIN Dept_Master as correct
ON SOUNDEX(orig.Department) = SOUNDEX(correct.Department_Name)
WHERE orig.Department  NOT IN (SELECT Department_Name FROM Dept_Master)

尝试了这个，但得到NULL值字符串'marketing'和' making '作为soundex下降元音只有因为两者都有相同的soundex字符串值。我怎么解决它?

Answer 1

select distinct orig.Emp_ID,(orig.department) from Emp_Master as orig,Dept_Master as correct 
where orig.Department not in (select Department_Name from Dept_Master);