Outer joins are divided into left outer join, right outer join and full outer join. The inner join we learned earlier obtains records that meet the conditions, and the records that do not meet the conditions in the join query table are removed. The characteristic of outer joins is that the query results may not meet the conditions.
1. Left outer join
Left outer join queries all the records in the left table. The values of the columns in the right table corresponding to the records in the left table that do not meet the conditions are displayed as NULL. The keyword of left outer join is: LEFT OUTER JOIN, and the corresponding sql statement is as follows:
SELECT * FROM table 1 alias 1 LEFT OUTER JOIN table 2 alias 2 ON alias 1. column name = alias 2. column name
where table 1 is The left table is also called the main table, and Table 2 is the right table.
Use left outer join to query the information of each employee and department information. The corresponding query statement is: select * from emp e left outer join dept d on e.deptno=d.deptno,
It can be seen from the query results that when the left table When the records do not meet the conditions, the value of the column in the right table is null.
2. Right outer join
Right outer join queries all the records in the right table. The values of the columns in the left table corresponding to the records in the right table that do not meet the conditions are displayed as NULL. The keyword for right join is: RIGHT OUTER JOIN, and the corresponding sql statement is as follows:
SELECT * FROM table 1 alias 1 RIGHT OUTER JOIN table 2 alias 2 ON alias 1. column name = alias 2. column name
where table 1 is the left Table, Table 2 is the right table, also called the main table.
Use right outer join to query the information of each department and the department’s employee information. The corresponding query statement is: select * from emp e right outer join dept d on e.deptno=d.deptno,
3. Full outer join
Full outer join has no restrictions on the left table and the right table. All records are displayed, and the places in the two tables that do not meet the conditions are filled with null. The keyword of full outer join is: FULL OUTRE JOIN, and the corresponding sql statement is as follows:
SELECT * FROM Table 1 Alias 1 FULL OUTER JOIN Table 2 Alias 2 ON Alias 1. Column name = Alias 2. Column name
MySQL database does not support Full outer join, but from an analysis point of view, full outer join combines the results of left outer join and right outer join.
Use full outer join to query the information of emp table and dept table
SELECT
*
FROM
emp e LEFT OUTER JOIN dept d
ON
e.deptno=d.deptno
UNION
SELECT
*
FROM
emp e RIGHT OUTER JOIN dept d
ON
e.deptno=d.deptno
In the query results in Figure 1-3, the corresponding positions in the two tables that do not meet the conditions are replaced by null.
Use left outer join query. The left table is e1, so all employee names in the e1 table are queried, and the positions in the e2 table that do not meet the conditions are replaced with null.

本篇文章给大家带来了关于java的相关知识,其中主要介绍了关于结构化数据处理开源库SPL的相关问题,下面就一起来看一下java下理想的结构化数据处理类库,希望对大家有帮助。

本篇文章给大家带来了关于java的相关知识,其中主要介绍了关于PriorityQueue优先级队列的相关知识,Java集合框架中提供了PriorityQueue和PriorityBlockingQueue两种类型的优先级队列,PriorityQueue是线程不安全的,PriorityBlockingQueue是线程安全的,下面一起来看一下,希望对大家有帮助。

本篇文章给大家带来了关于java的相关知识,其中主要介绍了关于java锁的相关问题,包括了独占锁、悲观锁、乐观锁、共享锁等等内容,下面一起来看一下,希望对大家有帮助。

本篇文章给大家带来了关于java的相关知识,其中主要介绍了关于多线程的相关问题,包括了线程安装、线程加锁与线程不安全的原因、线程安全的标准类等等内容,希望对大家有帮助。

本篇文章给大家带来了关于Java的相关知识,其中主要介绍了关于关键字中this和super的相关问题,以及他们的一些区别,下面一起来看一下,希望对大家有帮助。

本篇文章给大家带来了关于java的相关知识,其中主要介绍了关于枚举的相关问题,包括了枚举的基本操作、集合类对枚举的支持等等内容,下面一起来看一下,希望对大家有帮助。

封装是一种信息隐藏技术,是指一种将抽象性函式接口的实现细节部分包装、隐藏起来的方法;封装可以被认为是一个保护屏障,防止指定类的代码和数据被外部类定义的代码随机访问。封装可以通过关键字private,protected和public实现。

本篇文章给大家带来了关于java的相关知识,其中主要介绍了关于设计模式的相关问题,主要将装饰器模式的相关内容,指在不改变现有对象结构的情况下,动态地给该对象增加一些职责的模式,希望对大家有帮助。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Dreamweaver Mac version
Visual web development tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 Mac version
God-level code editing software (SublimeText3)

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
