1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Select Not Matching Data With Join Table

[Solved] Select Not Matching Data With Join Table | Sql - Code Explorer | yomemimo.com
Question : select not matching data with join table

Answered by : samy

SELECT Name, Gender,country, Salary, DeptName
FROM tbl_Employee
LEFT OUTER JOIN tbl_Department
ON tbl_Employee.DepartmentId = tbl_Department.DeptId
where tbl_Employee.DepartmentId is null

Source : | Last Update : Wed, 24 Nov 21

Answers related to select not matching data with join table

Code Explorer Popular Question For Sql