Sql

Search

select not matching data from two tables

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: postgresql reset sequence
Sql :: sql server reset id
Sql :: insert column after column mysql
Sql :: identity insert on sql server
Sql :: create database mysql utf8
Sql :: alter table add column boolean
Sql :: show size of all tables postgres
Sql :: drop stored procedure mysql
Sql :: oracle sql limit results
Sql :: sql server find columns list in tables
Sql :: get column name sql server
Sql :: mysql CURRENT_TIMESTAMP()
Sql :: mysql get date diff in months
Sql :: sql not start with vowel
Sql :: mysql database stopped xampp mac
Sql :: mysql print variable
Sql :: sql script get all stored procedures from database
Sql :: tsql merge example
Sql :: raise application error in oracle
Sql :: convert varchar to int in sqlite
Sql :: alter table engine mysql
Sql :: linux command line import mysql database
Sql :: start mysql server mac
Sql :: find last instance of character in string mysql
Sql :: mysql loop insert
Sql :: sql server find all foreign keys that reference a column
Sql :: alter user root mysql
Sql :: postgresql format date dd/mm/yyyy
Sql :: jooq convert using gbk
Sql :: check sql database table lock

Search

SQL

select not matching data from two tables

ADD CONTENT