Ex 01 SQLJoins
Ex 01 SQLJoins
Ex 01 SQLJoins
$ $
%%%&'()*('+,&-.*&/0$
1)(023.$4,0,$+*40(223.5$
6+78$.0+9+7,:;$<==42;>>%%%&'()*('+,&-.*&/0>2?:@A.+7@(7=(7',@-.*.@BC7-+.7,@.@0(=.07.@'.2@','.2>DEFFG
HIJKLMNOPKQORSOTUKVMWMKXYOVNMOUKMKZSRMZOMKTM[KTUTM[
Q[RSKUZRN\MKTSWMO[RZUZ]KTSKXMZWUK^Z]RNVUKVMWMKXYOVNMOUKVUTUK_MNOKTM
HIJKSKMK̀YSKZSRMZOUZ]KTSKTUTM[a
b c d cecc f g
678h he cijc hkN\YZUKli
mn oph q r g h p
soh mn ctuvw c
g tp c o c cw
:;<=>;>?@ABAB>CDE<?F<B@<BF<GF<G
H I J KL MJ NO
P QPR P Q STS
U J Q L I VO PR
PTKL O P P WXYZOQV
P[\]^_`abcde
fghijhkjilmhkjnopqnirk
kkstupkvnwxynwrz{|ks}mmk
|k
kkk
~k
kkk
fghijhkjilmhkjnopqnlrk
kkstupkvnwxynwrz{|ks}mmk
|k
EGF><CB
RO PI PR Q
PJ K6 O O
\]^_`abcdPR RQJ QL
POI QJ
shgjksjkjnopqnikim}hrpwnn|k
shgjksjkjnopqnikim}hrtpn|k
shgjksjkjnopqnikim}hrm ¡|k
shgjksjkjnopqnikim}hrpwnt|k
kkk
shgjksjkjnopqnlkim}hrfnwqt|k
shgjksjkjnopqnlkim}hr¢ntpq|k
shgjksjkjnopqnlkim}hrm ¡|k
shgjksjkjnopqnlkim}hrpwnt|k
EGF><CB£¤¥
$%&'(&$)&'*$*+(,-$.+)+$.,'&,$(&6.+*$-$¦&(-/&*$6+$%78$%-,§-,9
456789:;?@ 01 -
AB5CD96EF:G H3 3 / 2 456789:G
3
IJKJLMNOPQRSTUNVPQRSTN
WXYZNMOVT[O\NO]N\N
^QQJXN_Y^QNMOVT[O`NO]N`N
NNNNNNNNNNNNNNNNRaNOPQRSTNbNVPQRSTN
c+defg&h(ijklmnopqkqkroostkuqvo
456789:G?@3 -
c&we()*+%
,8 2/ .3 456789:x2 3
<=1 3yz = 1 / 3{| <
3{=1 >3y
%&'()*+=-.2 8
pY]q[r̀sYt
u .< 3 %&'()*+v3 2
<w0 2xy w 0 : 2z{ <
2zw0 |2x
%&'()*+<-.: .1
qr\_satuZv
ww xy z::w z:: {;
%&'()*+|; : 1}0 :~ 1
:
$%&'()*?,-2 0
tu5 32PUDAO 7 21 3 34
4/ NUBBEVPWH3 2 v
wxyz{yw|yz}w}~{w~|~wzzyw~ww~zw~wy
[a^c\`c\
t$%&'()* ./ 5v 842 5 36
2 56/ 26 / > 2
%&'()*+,,./3 823 4
{^b|`e}~^be^
5/423 4 = 3%&'()*+,= 3
41 3 1 6 3
= 2 7&89*':;+ 3 =
4 %&'()*+,
$%&'()*+p-3
qrVYs[tuvwrxTyX[z{Ty
| }23 1 ~ $%&'()*+~ 3
10 3~ 0 3~
10 3~ 0 3