price sales

65 1
45 2
12 3
id name sal DEPTtID Deptid DeptName
101 AAA 5000 D01 D01 IT
102 BBB 6000 D01 D02 Sales
103 CCC 6500 D02 D03 HR
104 DDD 4000 D02 D04 Audit
105 EEE 5500 D03 D05 Finance
109 RRR 8500 D06
108 YYY 75000 D07
Emp Dept

Right Outer Join

Left Outer Join id name sal DEPTid
id name sal deptid DeptName 101 AAA 5000 D01
101 AAA 5000 D01 IT 102 BBB 6000 D01
102 BBB 6000 D01 IT 103 CCC 6500 D02
103 CCC 6500 D02 SALES 104 DDD 4000 D02
104 DDD 4000 D02 SALES 105 EEE 5500 D03
105 EEE 5500 D03 HR NULL NULL NULL NULL
109 RRR 8500 D06 NULL NULL NULL NULL NULL
108 YYY 75000 D07 NULL

TABLEA

ID
ID ID 1
1
1
 2
2
NULL

NULL

LEFT OUTER JOIN RIGHGT OUTER

1 1 1
1 1 1
1 1 1
2 2 2
2 2 2
2 2 2
2 2 2
NULL NULL NULL
Full Outer Join Left Anti
id name sal deptid DeptID DeptName id name sal deptid
101 AAA 5000 D01 D01 IT 109 RRR 8500 D06
102 BBB 6000 D01 D01 IT 108 YYY 75000 D07
103 CCC 6500 D02 D02 SALES
104 DDD 4000 D02 D02 SALES
105 EEE 5500 D03 D03 HR
109 RRR 8500 D06 NULL NULL Right Anti
108 YYY 75000 D07 NULL NULL id name sal deptid
NULL NULL NULL NULL D04 Audit NULL NULL NULL NULL
NULL NULL NULL NULL D05 Finance NULL NULL NULL NULL
Inner Join
DEPT.DeptID DeptName id name sal deptid DeptName
D01 IT 101 AAA 5000 D01 IT
D01 IT 102 BBB 6000 D01 IT
D02 SALES 103 CCC 6500 D02 SALES
D02 SALES 104 DDD 4000 D02 SALES
D03 HR 105 EEE 5500 D03 HR
D04 Audit
D05 Finance

TABLEB ID
1
ID 1
1 1
2 1
2 NULL 3 2
 3 2
2
NULL

NULL

GHGT OUTER INNER JOIN

1 1 1
1 1 1
1 1 1
2 2 2
2 2 2
2 2 2
2 2 2
3
DeptName
NULL
NULL

Deptid DeptName
D04 Audit
D05 Finance

ID
1
1
2
2
3
 3
NULL
NULL
Pid Name sale amount date Pid
p1 AAA 30000 2/11/2020 p1
p2 BBB 30000 3/11/2020 p2
p3 CCC 30000 4/11/2020 p3
p4 DDD 30000 5/11/2020 p4
Sale - 2020 table Sale - 2019 table
Normal Case sensetive
Pid Name sale amount date Pid
p1 AAA 30000 2/11/2020 p1
p2 BBB 30000 3/11/2020 p2
p3 CCC 30000 4/11/2020 p3
p4 DDD 30000 5/11/2020 p4
p1 AAA 30000 2/11/2019 p1
p2 BBB 40000 3/11/2019 p2
p3 CCC 50000 4/11/2019 p3
p4 DDD 70900 5/11/2019 p4
p1 AAA 30000 2/11/2018
p2 BBB 40000 3/11/2018 Pid
p3 CCC 50000 4/11/2018
p4 DDD 70900 5/11/2018

eid name
1a
2b
eid name dptid dptname
1a NULL NULL
2b NULL NULL
NULL NULL 123 sale
NULL NULL 124 hr
eid name

1a
2b
2B

2C

NULL NULL
 Name sale amount date Pid Name
AAA 30000 2/11/2018 p1 AAA
BBB 40000 3/11/2018 p2 BBB
CCC 50000 4/11/2018 p3 CCC
DDD 70900 5/11/2018 p4 DDD
Sale - 2019 table Sale - 2018 table
Case sensetive
Name Sale Amount date sale amount
AAA 30000 2/11/2020 NULL
BBB 30000 3/11/2020 NULL
CCC 30000 4/11/2020 NULL
DDD 30000 5/11/2020 NULL
AAA NULL 2/11/2019 30000
BBB NULL 3/11/2019 40000
CCC NULL 4/11/2019 50000
DDD NULL 5/11/2019 70900
Name Sale Amount date

dptid dptname eid

123 sale 1
124 hr 2
NULL
NULL

DEPT DPTNAME

123 sale
124 hr
NULL NULL

NULL NULL

NULL NULL
 Sale Amountdate
30000 2/11/2018 Same Column
40000 3/11/2018 Pid Name
50000 4/11/2018 p1 AAA
70900 5/11/2018 p2 BBB
p3 CCC
Sale - 2018 table p4 DDD
p1 AAA
Column order p2 BBB
date Pid Name sale amount p3 CCC
2/11/2019 p1 AAA 30000 p4 DDD
3/11/2019 p2 BBB 40000
4/11/2019 p3 CCC 50000
5/11/2019 p4 DDD 70900
2/11/2020 p1 AAA 30000
3/11/2020 p2 BBB 30000
4/11/2020 p3 CCC 30000
5/11/2020 p4 DDD 30000

name dptid dptname

a NULL NULL
b NULL NULL
NULL 123 sale
NULL 124 hr
sale amoundate
30000 2/11/2020
30000 3/11/2020
30000 4/11/2020
30000 5/11/2020
30000 NULL
40000 NULL
50000 NULL
70900 NULL

EID NAME DEPTID

1 AA 100
2 BB 200
NULL CC NULL
NULL DD NULL
DEPTNAME
IT
SALES
NULL
NULL
Dates SalesamountMTD QTD
1/1/2021 300 300 300
1/2/2021 200 500 500
1/3/2021 400 900 900
1/4/2021 300 1200 1200
1/5/2021 500 1300 1300
2/1/2021 200 200 1500
2/2/2021 400 600 1900
2/3/2021 300 900 2200
2/4/2021 500 1400 2700
3/1/2021 400 400 3100
3/2/2021 300 700 3400
3/3/2021 500 1200 3900
3/4/2021 200 1400 4100
3/5/2021 400 1800 4500
4/1/2021 300
4/2/2021 500 TABLE A TABLE B
4/3/2021 400
4/4/2021 300 ID NAME ID NAME
4/5/2021 500 1A 3C
5/1/2021 300 2B 4D
5/2/2021 500
5/3/2021 200
5/4/2021 400
5/5/2021 300