Ex 01 SQLJoins

Download as pdf or txt
Download as pdf or txt
You are on page 1of 9

0121324315 678          

$ $
%%%&'()*('+,&-.*&/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

kN\YZUKlax mn op g 


so  c g c h   ych 
c uh      e   

2222  !0133" 12#
0121324315 678          
$%&'(&$)&'*$*+(,-$&$./01*1/&$2345$6+$%789

:;<=>;>?@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 
 P’J K“6  O  O 
\]^_`abcd”PR RQJ QL   
POI QJ  ’
•s–hgjk•sjkjnopqnik—im}h–r˜™pwšnš›n˜|k
•s–hgjk•sjkjnopqnik—im}h–r˜œtpžn˜|k
•s–hgjk•sjkjnopqnik—im}h–r˜mŸ ¡˜|k
•s–hgjk•sjkjnopqnik—im}h–r˜™pwšnš›t˜|k
kkk
•s–hgjk•sjkjnopqnlk—im}h–r˜fnwqt˜|k
•s–hgjk•sjkjnopqnlk—im}h–r˜¢nštpq˜|k
•s–hgjk•sjkjnopqnlk—im}h–r˜mŸ ¡˜|k
•s–hgjk•sjkjnopqnlk—im}h–r˜™pwšnš›t˜|k
€EGF><CB£ƒ„¤‰Œ†‡‰Š‹„†¥‡Œ†‹Œ„‘ˆ†ˆ„ŒŒ
$%&'(&$)&'*$*+(,-$.+)+$.,'&,$(&6.+*$-$¦&(-/&*$6+$%78$%-,§-,9

2222  !0133" 42#


0121324315 678          
$%%&'()*+%
,-  . . / 01   2 3456789:;2 
<=1  >3

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

2222  !0133" 02#


0121324315 678          

%&'()*+,-. /0  8


1 2 3  42 5&67*'89+,3:2 ;
   < %&'()*+=
>?@?ABCDEFGHIJCKEFGHIC
LMNOCBDKIPDQCDRCQC
@?LBCSNTFCBDKIPDUCDRCUC
CCCCCCCCCCCCCCCCGVCDEFGHICWCKEFGHIC
XYZ[\]^_àbcdefghicicjklmcniog

%&'()*+=-.2  8

pY]q[r̀sYt
u  .< 3  %&'()*+v3  2   
<w0 2xy w 0 : 2z{ <
2zw0  |2x

2222  !0133" #2$


0121324315 678          

%&'()*+,-. /0  .1


23&45*'67+8  9:  :; %&'()*+< 
: 
=>?>@ABCDEFGHIBJDEFGHB
KLMNBACJHOCPBCQBPB
LRSTABUMREBACJHOCVBCQBVB
BBBBBBBBBBBBBBBBFWBCDEFGHBXBJDEFGHB
YZ[\]^_`abcdefghijdjdklmnodpjlh

%&'()*+<-.:  .1

qr\_satuZv
ww xy    z::w z:: {;  
%&'()*+|;  :   1}0 :~  1
:

2222  !0133" #2$


0121324315 678          

$%&'()*+,- ./  0


1 2 3 4 25  67
  8%9:)&;<*=3> 7  $%&'()*?
@ABACDEFGHIJKLEMGHIJKE
NOPQEDFMKRFSEFTESE
NUBBEPUDAOEVPWHEDFMKRFXEFTEXE
EEEEEEEEEEEEEEEEIYEFGHIJKEZEMGHIJKE
[\]^_`abcdefghijklflfmnopqfrlsj

$%&'()*?,-2  0
tu5 32PUDAO 7  21  3  34 
 4/ NUBBEVPWH3 2 v  
wxyz{yw|yz}w}~{€w~|~w‚ƒz„zyw~w†‚ƒ€w‡~zˆwˆ~w†y„€‰

[aŠ^c‹ŒŽ\‘`c’“\‘
t$%&'()*”•  ./ 5v 842 5 36
2   56/ 2–6 / > 2—

2222  !0133" "2#


0121324315 678          

%&'()*+,-./ 01  823 4


5  6    7&89*':;+<=3 > 
%&'()*+,,
?@A@BCDEFGHIJKDLFGHIJD
MNOPDCELJQERDESDRD
A@MCDTOUGDCELJQEVDESDVD
DDDDDDDDDDDDDDDDHWDEFGHIJDXDLFGHIJD
YZ@N@DLFGHIJD[SDW\QQD
]^_`abcdefghijklmnhopqrhstuvwmxlyhznxl

%&'()*+,,./3  823 4

{^b|`e}~€‚^ƒbe„^ƒ
5/423 4 = 3%&'()*+,†= 3   
4‡1 3ˆ‡ 1 6 3‰Š  
‹=  2   7&89*':;+Œ  3 =  
 4   %&'()*+,Ž

2222  !0133" #2$


0121324315 678          

$%&'()*+,-. /0  .123 1


4565789:;<=>?@9A;<=>?9
BCDE98:A?F:G9:H9G9
CIJK89LDI<98:A?F:M9:H9M9
9999999999999999=N9:;<=>?9O9A;<=>?9
PK5C59:;<=>?9QH9NRFF9
STUVWXYZ[\]^_àbacdefg^haij`^klmbnfaei^ogae

$%&'()*+p-3

qrVYs[tuvwrxTyX[z{Ty
|  }23 1 ~  $%&'()*+~  3
  1€0 3~€ 0 ‚ 3ƒ~  
1€0 3ƒ~€ 0 ‚ 3

$%&'()*+-. /0  }23 1

2222  !0133" 52#


0121324315 678          
$%& '()*+,-./0  1 21  3
4  56789 :  ;  ;1   <6==>?5@A;
3 2  
B8=8C7>DEAFGHI>JEAFGH>
<95K>7DJHLDM>DN>M>
<6==>56789>?5@A>7DJHLDO>DN>O>
>>>>>>>>>>>>>>>>FP>DEAFGH>Q>JEAFGH>
RS898>DEAFGH>TN>PULL>FV>JEAFGH>TN>PULL>
WXYZ[\]^_`abcdefghbijklmbnopqjgrfsbthrf
$3  3  u(,vw+/xy

u(,vw+/xyz{3  $13 &


|323 $}4 3&& 678~ 1 3€ 
‚ ;  ;   :  3 3  
 3  6786; ƒ„678; ;
†‡ˆ‰Šˆ†‹ˆ‰Œ†ŒŠŽ††Œ†‘†’‰“Œ†“†”‰ŽŠ‰Ž‘•
–—˜™š›–™œžŸ›¡ž¢›£–—›¡Ÿœ¤›š–¥˜¡¢ž¦œ¡¤žš–¢œ–§ž¡Ÿ›–¢œ–¢ž¢›š
–—˜™š›–™œžŸ›¡ž¢›£–¨¢¦ ¡š¤™ž©ª›–¢œ–«ž¡Ÿ›–¢œ–¬ž¢›š–Ÿ›¦–­®¯–­œ™°œ™
–—˜™š›–™œžŸ›¡ž¢›£–±™žŸœ

2222  !0133" #2#

You might also like