Sql

Search

select not matching data with join table

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 :: TSQL GET ALL COLUMNS IN TABLE
Sql :: sql find text in sp
Sql :: ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
Sql :: alter user mysql native password
Sql :: Find all triggers in database
Sql :: identity_insert is set to off
Sql :: forgot my mysql password mac
Sql :: sql add column after another
Sql :: fetch first 5 rows in oracle sql developer
Sql :: oracle get current schema
Sql :: show tables sql server
Sql :: set default today mysql
Sql :: alembic.util.exc.CommandError: Target database is not up to date.
Sql :: install mysql ubuntu 18.04
Sql :: mac xampp mysql not starting
Sql :: mysql find tables with column name
Sql :: alter schema sql
Sql :: Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
Sql :: Row Number is sql server
Sql :: show all sequence in postgresql
Sql :: mysql get last day of month
Sql :: set database timezone mysql
Sql :: start mysql server
Sql :: sql padd let with zeros
Sql :: mysql 8 error on identified by
Sql :: cannot pip install mysqlclient
Sql :: Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Sql :: postgresql create table with index
Sql :: set statistics on in ssms
Sql :: django sqllite config

Search

SQL

select not matching data with join table

ADD CONTENT