Take a look at the results of the left join and the right join with the Inner join and the full join to manipulate the table.
Create a new two table in the database and insert the data you want to test.
New table:[SQL]View PlainCopy
Use [Test]
GO
/*****
The join syntax is as follows: select [field] from [Table Name 1] inner/left/right/full join [Table name 2] on [Table Name 1. field 1] [Table name 2. field 2] cross join: the product of the flute. without any constraints, the number of rows in a table is multiplied by the number of rows in another table. Left
Label:Original: http://blog.csdn.net/shadowyelling/article/details/7684714Left Join: Returns all the information in the table on the right and the information related to the left table conditionRight Join: Returns all of the information in the table in the list and information about the right table condition in the left tableInner Join: Returns information common
Differences between inner join, left JOIN, right join, outer join in SQLFor example, you'll know!Table A (A1,B1,C1) b (A2,B2)A1 B1 C1 A2 B201 Mathematics 95 01 Sheets Three02 Language 90 02 John Doe English Harry Select A.*, b.* from AINNER
Update Update Xxx Set Xxx Where As we all know about this writing, we found that update and delete support the update method of inner join, which is very useful for updating and deleting operations between tables. Column: SQLCode Update Tb_user Set Pass = '' From Tb_user USR Inner Join Tb_address ADDR
[Test @ ora1] SQL> select * From A; No. Name ---- ---------- 1000 Zhang San 2000 Li Si 3000 Wang Wu [test @ ora1] SQL> select * from B; product NO. ---- ---------- 1000 TV set 2000 video recorder 4000 bicycle [test @ ora1] SQL> set null Null Value -- Here I define null as [null value] [test @ ora1] SQL> select. *, B. * From a inner join B on. no. = B. no.; No. name No. Product ---- ---------- 1000 Zhang San
Label: Inner JOIN (equivalent connection) returns only rows that have the same join field in two tables Left join returns records containing all the records in the left table and the equivalent of the junction fields in the right table Right join returns records that contain
Label: INNER JOIN (equivalent join) returns only rows that have the same join field in two tables Left join returns records that include all the records in the left table and the equivalent of the junction fields in the right table Right
This article is reproduced in SQL using update inner join and delete inner join.
Because the Update Connection statement is required when processing data in the project, the update inner join syntax is used. Here we repost the sta
Inner JOIN (equivalent connection) returns only rows that have the same join field in two tablesLeft join returns records containing all the records in the left table and the equivalent of the junction fields in the right tableRight join returns records that contain all the
Inner JOIN (equivalent connection) returns only rows that have the same join field in two tablesLeft join returns records containing all the records in the left table and the equivalent of the junction fields in the right tableRight join returns records that contain all the
Inner JOIN (equivalent connection) returns only rows that have the same join field in two tablesLeft join returns records containing all the records in the left table and the equivalent of the junction fields in the right tableRight join returns records that contain all the
INNER JOIN (equivalent join) returns only rows that have the same join field in two tablesLeft join returns records that include all the records in the left table and the equivalent of the junction fields in the right tableRight join
INNER JOIN (equivalent join) returns only rows that have the same join field in two tablesLeft join returns records that include all the records in the left table and the equivalent of the junction fields in the right tableRight join
INNER JOIN (equivalent join) returns only rows that have the same join field in two tablesLeft join returns records that include all the records in the left table and the equivalent of the junction fields in the right tableRight join
Tags: style os using ar strong data SP Div ArtInner JOIN (equivalent connection) returns only rows that have the same join field in two tablesLeft join returns records containing all the records in the left table and the equivalent of the junction fields in the right tableRight join returns records that contain all the
Inner JOIN (equivalent connection) returns only rows that have the same join field in two tablesLeft join returns records containing all the records in the left table and the equivalent of the junction fields in the right tableRight join returns records that contain all the
I. Let's take a look at some of the simplest examples.
Example
TableAid adate1 a12 a23 a3
TableB
Bid bdate1 b12 b24 b4Two tables a and B are connected. fields with the same id must be retrieved.Select * from a inner join B on a. aid = B. bid this is only used to retrieve matching data.In this case, the following information is taken:1 a1 b12 a2 b2
Then left join
I. Let's take a look at some of the simplest examples.
Example
TableAid adate1 A12 A23 A3
Tableb
Bid bdate1 B12 B24 B4Two tables A and B are connected. fields with the same ID must be retrieved.Select * from a inner join B on A. Aid = B. Bid this is only used to retrieve matching data.In this case, the following information is taken:1 A1 B12 A2 B2
Then left jo
Label:Simply and clearly, connect to the inner and outer links. Suppose there are two tables of A and B Internal connection: Inner JOIN indicates that the record of the AB table is displayed, excluding the condition of the AB table . There are three kinds of outer joins, that is, left OUTER joins, right connection, OUTER join
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.