SQL Server two-Table relationship Query

1. Create two tables Table1 and Table2. The table structure is as follows:

2. initialize table data

Table1

1	A20050111
2	A20050112
3	A20050113
4	A20050114
5	A20050115

Table 2

1	2006032401
2	2006032402
3	2006032403
4	2006032404
8	2006032408

3. Where Query

Select * From Table1 A, Table2 B Where a. Aid = B. Bid

Query results:

1 a20050111 1 2006032401

2 a20050112 2 2006032402

3 a20050113 3 2006032403

4 a20050114 4 2006032404

4. Left join query

Select * From Table1 Left join Table2 B On a. Aid = B. Bid

Query results:

1 a20050111 1 2006032401

2 a20050112 2 2006032402

3 a20050113 3 2006032403

4 a20050114 4 2006032404

5 a20050115 null

5. Right join query

Select * From Table1 Right join Table2 B On a. Aid = B. Bid

Query results:

1 a20050111 1 2006032401

2 a20050112 2 2006032402

3 a20050113 3 2006032403

4 a20050114 4 2006032404

Null null 8 2006032408

6. Inner join query

Select * From Table1 Inner join Table2 B On a. Aid = B. Bid

Query results:

1 a20050111 1 2006032401

2 a20050112 2 2006032402

3 a20050113 3 2006032403

4 a20050114 4 2006032404