Joins
---------------------------------extracted form ref
Equijoins: Combines rows that have equivalent values for the specified columns.
Self Joins: A join of a table to itself.
Cartesian Products: If no join condition, returns Cartesian product. Combines each row of one table with each row of the other.
Innerjoins: (or named Simple Join) A join of two or more tables that returns only those rows that satisfy the join condition.
Outerjoins: Extends the result of a simple join. Retuns all rows that satisfy the join condition and also returns some or all of those rows form one table for which no rows from the other satisfy the join condition. Left Outer Join: If performs an outer join of table A and table B and returns all rows from A use the LEFT[OUTER] JOIN sytax in the FROM clause, or apply the outer join perator(+) to all columns of B in the join condition in the WHERE clause. Right Outer Join acts can be deduced like left outer join. Full Outer Join: Returns all rows form A and B, extended with nulls if they do not satisfy the join condition, use the FULL[OUTER] JOIN syntax in the FROM clause.
Antijoins: Returns rows form the left side of the predicate for which there are no corresponding rows on the right side of the redicate. That is rows that match in A , not in B(suppose A is the left side).
Semijoins: Returns rows that match an EXISTS subquery without duplicating rows from the left side of the predicate when mutiple rows on the right side satisfy the criteria of the subquery.
分享到:
相关推荐
sql joins with simple description in a diagram
General SQL statement and Joins
SQL Joins Visualizer帮助您使用维恩图在两个表之间构建SQL JOIN。 发展历程 。 Web应用程序基于构建。 要以开发模式启动它,需要安装ruby并在终端中运行: $ bundle # get all deps $ middleman server # start ...
SQL_JOINS
AAIT_SQL_JOINS.pdf https://blog.csdn.net/jx520/article/details/122786867
mysql笔记 mysql学习的利器 SQL JOINS.png
This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, ...
手写手写SQL顺序机读顺序总结-SQL解析顺序SQL解析SQLJOINs七种JOIN图解实验:练习1、A、B两表共有2、A、B两表共有+A的独有3、A、B两表共有+B的独有4、A的独有5、B的独有6、AB全有MySQLFullJoin的实现因为MySQL不支持...
开源项目-go-pg-pg.zip,ORM for Postgres with SQL joins that are 2x-10x faster than GORM (sharding included)
Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries....
开源项目-go-pg-pg#why-go-pg.zip,ORM for Postgres with SQL joins that are 2x-10x faster than GORM (sharding included)