jjzjj

tblDepartment

全部标签

mysql - SQL 左连接查询区别

左边的tblEmployee表和右边的tblDepartment表第一个查询:SelectName,Gender,Salary,DepartmentNamefromtblEmployeeLeftJointblDepartmentOntblEmployee.departmentID=tblDepartment.IdWheretblEmployee.departmentIDISNull;第二个查询:SelectName,Gender,Salary,DepartmentNamefromtblEmployeeLeftJointblDepartmentOntblEmployee.departme