sql inner join example

, and the left join is based on left table. in other words, the records of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria ( In the example: A.aid = b.bid). b table records are null. -------------------------------------------- 2.right join

20060324045 a20050115 NULL NULL(The number of rows affected is 5 rows)Result Description:The left join is based on the records of Table A, a can be regarded as the right table, and B can be regarded as left table.In other words, the records of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria (in the example: A.aid = b.bid).The low-

regarded as left table.In other words, the records of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria (in the example: A.aid = b.bid).The low-record of table B is null.--------------------------------------------2.right JoinThe SQL statements are as follows:SELECT * FROM ARight Join BOn

table, and B can be regarded as left table.In other words, the records of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria (in the example: A.aid = b.bid).The low-record of table B is null.--------------------------------------------2.right JoinThe SQL statements are as follows:SELECT * FROM ARight

, the records of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria (in the example: A.aid = b.bid).The low-record of table B is null.--------------------------------------------2.right JoinThe SQL statements are as follows:SELECT * FROM ARight Join BOn a.aid = B.bid The results are as foll

of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria (in the example: A.aid = b.bid).The low-record of table B is null.--------------------------------------------2.right JoinThe SQL statements are as follows:SELECT * FROM ARight Join BOn a.aid = B.bidThe results are as follows:AID Anum B

a20050114 4 20060324045a20050115 NULL null (the number of rows affected is5rows) The results show that the left join is based on the records of a table, a can be regarded as the right table, and B can be regarded as left table. In other words, the records of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria (in the example: A.aid=b.

ObjectiveThis section begins with our join learning, about connecting this piece involves more content, we step by step learning, short content, in-depth understanding.Crossover join (Cross join)Cross joins are the simplest type of join. A cross join performs only one logica

Objective At the beginning of this section we entered the join learning, about the connection of this piece of content more, we step-by-step study, short content, in-depth understanding. Cross join (CROSS join) Cross joins are the simplest type of join. A cross join perfo

is not satisfied, because the supplier code is really meaningless to humans, join can help at this time. By joining the suppliers table, we can query the Supplier name. Select productid, productname, suppliers. supplierid, suppliers. companyName from products inner join suppliers on products. supplierid = suppliers. supplierid order by productname Outer

of the left table (A) will all be represented, and the right table (B) will only display records that match the search criteria (in the example: A.aid = b.bid).The low-record of table B is null.--------------------------------------------2.right JoinThe SQL statements are as follows:SELECT * FROM ARight Join BOn a.aid = B.bidThe results are as follows:AID Anum B

table has a value, and no match is substituted with a null value.SELECT * from A left OUTER JOIN B on a.name = B.nameA 3.RIGHT [OUTER] JOIN produces a full set of Table B, and a match in table A has a value, and no match is substituted with a null value.SELECT * from A right OUTER JOIN B on a.name = B.nameThe 4.FULL [OUTER]