db2 outer join

In the following post, innerjoin = where = join Http://baike.360.cn/4241488/12057813.html Http://z.baidu.com/question/46996912.html? SI = 1 The connection statement used in the WHERE clause is called a recessive connection in the database language. Inner join ...... The connection generated by the on clause is called an explicit connection. (Other join paramet

1. A. Union select Column1, column2 from table1 Union select Column1, column2 from Table2 B. Intersection join SELECT * FROM table 1 as a JOIN table2 B on A.name=b.name c. No in SELECT * "from table1 WHERE name does not" (SELECT name from table2) d. Cartesian product The SELECT * FROM table1 CROSS JOIN table2 is the same as the select * from Table1,table2 2. The

TABLE EMPModify ename NOT null; --drop NOT NULL ContraintALTER TABLE EMPModify ENAME null;--drop constraintALTER TABLE EMPDrop constraint unique (name);ALTER TABLE EMPDrop constraint Fk_emp_deptno;--Disabling constraintsALTER TABLE EMPDisable constraint Fk_emp_deptno;--Enable constraintsALTER TABLE EMPEnable constraint Fk_emp_deptno;--oracle connection divided into inner join (inner join)

first, data constructionFirst build the table, then talk.Create DatabaseTest UseTestCreate TableA (AIDint Identity(1,1)Primary Key, namenvarchar( -), ageint)Create TableB (BIDint Identity(1,1)Primary Key, namenvarchar( -), Genderint)After creation, insert dataInsertA (Name,age)Values('Zhang San', *)InsertA (Name,age)Values('John Doe', -)InsertA (Name,age)Values('XXX', *)InsertA (Name,age)Values('YYY', *)InsertB (Name,gender)Values('Zhang San',1)InsertB (Name,gender)Values('John Doe',1)InsertB (N

Tags: load http Select detail LAN margin src lin bleExcerpt from: http://blog.csdn.net/scythe666/article/details/51881235 By default, the inner join, the left join and the right join used in development belong to the outer join, and the