ࡱ;   !"#$%&'()*+,-./0123456789:;<=>?@ABCEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry  !r\V)䰱 PresentationStarImpress 5.0FȔF8FTH 0F0F8+6FȪ@iap$kqLFFF0FFFFSfxDocumentInfo  Peter Dominey >18 Peter Dominey >1 >14:NTAUG Info 1 Info 2 Info 3 Info 4 >14:4P <44Standard LIBIMBEDDED LIBIMBEDDED1,,,1SBX sb : Standard StarBASICSBX ARSBX AR SBX ARSBX OBc BasicLibrariesBasicLibrariesSBX ARSBX AR SBX ARSBX OBe DialogLibrariesDialogLibrariesSBX ARSBX AR SBX AR2c%bqqOh+'0 h t 11@X2Y-@}6@;6@㰭6Peter DomineyPeter DomineyNTAUGnXOutdevItemPool 1   )     &'()*+,-./06789:;UVWXYZ[\]c !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstt      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefd)0%'@qXX',@X'.@2XXX' @X'c@~Arrow  XX'c@Arrow  XX'.@#,XXX'"@U,XX'@}XX'@X'(@ g5XXX'@~̙/*ffUXX X2XDXVXhXzX'@r22dd* Gradient 7dddd Gradient 8SSff dddd Gradient 9xxffddXX6XhX'(@X'@ BM F(YGSDP   ` x^k a nvOݓ`VɁ?$}7ǼoC# a>2P>x=j 2VA $Oi͠R D^`@K^*eJiS/|6c#+hG6S 1WYuʻR|Za}?o` j4Ys}|l䲁r_,7Uo;>Be]܏oGGן?<T^/@xD ɳA1y2`'Ql@Q"?'X(@ Fd=XXX;(+@1 XX,,6@s UffXX --.@ , GXXX...@ , GXXXJJ@ e * , !z-  ' #u, 3 .XXXX&X.X6X>XFXNXVX^XfKK@ RXXMM@ XXNN@ XXOO@ XXPP@A XXQQ@g f/XXSS@ XXUU@ XXVV@ 9XXX__@ X @ l 5''''')' 'XXX X,X8X>XDXJXVX\N@''''''''''''''''')'  '' '' ' ''''''XXX,XDX\XtXXXXXXXXX** d@ :5)')XXXX X&X,X2X8X>77 @ , ,,--..',,',,),,  ,,XXXX2X>XJXPXVX\XhXnHH @ 5+'<(@'<(@'()<(@'   %XXX X8XPXVX\XbXzXXXff@QQVV__ JJKKMMNNOOPPQQSSUUVV JJKKMMNNOOPPQQSSUUVVJJKKJJKK JJKKMMNNOOPPQQSSUUVVJJ KK JJKK 'QQVV  JJKKMMNNOOPPQQSSUUVV  JJ KKMMNNOOPPQQSSUUVV 'JJ& JJ KKMMNNOOPPQQSSUUVV" JJ KKMMNNOOPPQQSSUUVVJJ JJ KKMMNNOOPPQQSSUUVVXXX,XnXXXXXX.X@XRXXXX$XfXr8pEDc]Au:tT| . P o S  P|\CEditEngineItemPool v6f<0,Q*@XX*@XX* @g* +@ AZ" 9Times New RomandZ "X2StarBatsN-"2StarBatsN-"2StarBatsN-"` ` 2StarBatsN-" 2StarBatsN-"2StarBatsN-"hh2StarBatsN-"2StarBatsN-"2StarBatsN-"pp2StarBatsN- "2StarBatsN-"2StarBatsN-"2StarBatsN-"` ` 2StarBatsN-" 2StarBatsN-"2StarBatsN-"hh2StarBatsN-"2StarBatsN-"2StarBatsN-"pp2StarBatsN- Z3 Wingdings ffd3 Wingdings d 3 Wingdings ffd3 Wingdings d3 Wingdings ffd3 Wingdings ffd3 Wingdings ffd3 Wingdings ffd3 Wingdings ffdZ ZS3 Wingdings 88dH3 Wingdings ffd3 Wingdings dg 3 Wingdings ffd]3 Wingdings dS3 Wingdings dS3 Wingdings dS3 Wingdings dS3 Wingdings dS3 Wingdings 88dZ Z" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /ArialdZ Z" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /Ariald" /ArialdZ ZS3 Wingdings 88dH3 Wingdings 88d3 Wingdings XXdg 3 Wingdings ffd]3 Wingdings XXdS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dZ ZS3 Wingdings 88dH3 Wingdings 88d3 Wingdings dg 3 Wingdings 88d]3 Wingdings XXdS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dZ  ZS3 Wingdings 88dH3 Wingdings ffd3 Wingdings XXdg 3 Wingdings 88d]3 Wingdings XXdS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dZ  ZS3 Wingdings 88dH3 Wingdings 88d3 Wingdings @g 3 Wingdings 88d]3 Wingdings XXdS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dS3 Wingdings 88dZXXXX] XV XXX8XX#Xj' @B@6BRuXX&@ HC_dddx9dddY > ddd YD dddYDdddYDdddYD8ddd8YDXdddXYDxdddxYD!ddd!YDXX!X:XSXlXXXXX<( n@ C_9>  XXXX X&X,X2X8X>XD ( ;@ F StarSymbol!?-+Times New Roman!d88  Wingdings{!d)Arial!dff  Wingdings!dff  Wingdings!d=  Wingdings!dff  Wingdings{!d   Wingdings!@XXIXXXX3XmXX@'j@oGfdddddXdddd ddddddg dddg ]ddd] SdddSddHd6dddYH>dddYg dddg Y]ddd]YSdddSYXX!X4XGXZXmXXXXXXXXA'@ )Hdddddddd1dd 0dd dd dd dd iddXXX&X2X>XJXVXbXn1'F@Hh_^SXXX$X/+'(@H:XXX'V@K . . . . '. 1. ;. tE. `O. LY. 8c. $m.  3. . . #. -. 7. A. K. U. _. ki.  . . . . ). x3. d=. PG. . G. Q. [.  q. ]. I. 5%. !/. 9. B. L. V.  . . . . . ). x3. d=. PG. @N HG Mincho Light JArialXX**=@N Arial Unicode MSArialXX)* z@`Od id {d  d Od d d qd XXX"X,X6X@XJXT* z@Od id {d  d Od d d qd XXX"X,X6X@XJXT*@!P X*@@P X*@_P X*@~P X*@P X*@PX @P@PX{(@QpAmailto:pdominey@dominey.bizpdominey@dominey.bizW!X!p8http://www.dominey.biz/www.dominey.bizW!X!XXZ6^tx,,,-d.0!223M356I67+7S7r77778!878M8c8888+9t99:::::;<;R;p;P Wg* "2StarBatsN-"2StarBatsN-"2StarBatsN-"` ` 2StarBatsN-" 2StarBatsN-"2StarBatsN-"hh2StarBatsN-"2StarBatsN-"2StarBatsN-"pp2StarBatsN- ( StarSymbol!?-!''Nimbus Roman No9 L'Od $' ***HG Mincho Light J*Arial Unicode MS*Od *Od lt =I!2! 9xDefaultDefault4'''''''''''''''+;(,,--..**g* (@'A'1'+''!'''''''''%'$'************Object with arrowDefaultObject with arrow'''''''Object with shadowDefaultObject with shadow+;(,,--..Object without fillDefaultObject without fill'TextDefaultText'' Text bodyDefault Text body'''Text body justfiedDefaultText body justfied''+'First line indentDefaultFirst line indent''g*@'TitleDefaultTitle'''Title1DefaultTitle1 '''+;(,,--..+''Title2DefaultTitle2 ''+;(,,--..g*@'A'+''HeadingDefaultHeading''A''Heading1DefaultHeading1''A'''Heading2DefaultHeading2''A''''Dimension LineDefaultDimension Line'''''''Default~LT~Gliederung 1Default~LT~Gliederung 1"''**g*@' A'1'+''!''' ''''''%'$'************Default~LT~Gliederung 2Default~LT~Gliederung 1Default~LT~Gliederung 2**@'A' 1'+''!''' '''''%'$'*****Default~LT~Gliederung 3Default~LT~Gliederung 2Default~LT~Gliederung 3**@'A' 1'+''!''' '''''%'$'*****Default~LT~Gliederung 4Default~LT~Gliederung 3Default~LT~Gliederung 4**@'A' 1'+''!''''''''%'$'*** * *Default~LT~Gliederung 5Default~LT~Gliederung 4Default~LT~Gliederung 5**@'A' 1'+''!''''''''%'$'*** * *Default~LT~Gliederung 6Default~LT~Gliederung 5Default~LT~Gliederung 6**@'A' 1'+''!''''''''%'$'*** * *Default~LT~Gliederung 7Default~LT~Gliederung 6Default~LT~Gliederung 7**@'A' 1'+''!''''''''%'$'*** * *Default~LT~Gliederung 8Default~LT~Gliederung 7Default~LT~Gliederung 8**@'A' 1'+''!''''''''%'$'*** * *Default~LT~Gliederung 9Default~LT~Gliederung 8Default~LT~Gliederung 9**@'A' 1'+''!''''''''%'$'*** * *Default~LT~TitelDefault~LT~Titel#''QQ**g*@'A'1'+''!''' ''''''%'$'************Default~LT~UntertitelDefault~LT~Untertitel#''QQ**g*@'A'1'+''!''' ''''''%'$'************Default~LT~NotizenDefault~LT~Notizen"''**g*@'A' 1'+''!'''''''''%'$'***** * ******Default~LT~HintergrundobjekteDefault~LT~Hintergrundobjekte+;(,,--..Default~LT~HintergrundDefault~LT~Hintergrund''''QQVV+'TitleTitle@SubtitleSubtitle@Background objectsBackground objects@ Background Background@NotesNotes@ Outline 1 Outline 1@ Outline 2 Outline 1 Outline 2@ Outline 3 Outline 2 Outline 3@ Outline 4 Outline 3 Outline 4@ Outline 5 Outline 4 Outline 5@ Outline 6 Outline 5 Outline 6@ Outline 7 Outline 6 Outline 7@ Outline 8 Outline 7 Outline 8@ Outline 9 Outline 8 Outline 9@Title1~LT~Gliederung 1Title1~LT~Gliederung 1"''**g*@' A'1'+''!''' ''''''%'$'************Title1~LT~Gliederung 2Title1~LT~Gliederung 1Title1~LT~Gliederung 2**@'A' 1'+''!''' '''''%'$'*****Title1~LT~Gliederung 3Title1~LT~Gliederung 2Title1~LT~Gliederung 3**@'A' 1'+''!''' '''''%'$'*****Title1~LT~Gliederung 4Title1~LT~Gliederung 3Title1~LT~Gliederung 4**@'A' 1'+''!''''''''%'$'*** * *Title1~LT~Gliederung 5Title1~LT~Gliederung 4Title1~LT~Gliederung 5**@'A' 1'+''!''''''''%'$'*** * *Title1~LT~Gliederung 6Title1~LT~Gliederung 5Title1~LT~Gliederung 6**@'A' 1'+''!''''''''%'$'*** * *Title1~LT~Gliederung 7Title1~LT~Gliederung 6Title1~LT~Gliederung 7**@'A' 1'+''!''''''''%'$'*** * *Title1~LT~Gliederung 8Title1~LT~Gliederung 7Title1~LT~Gliederung 8**@'A' 1'+''!''''''''%'$'*** * *Title1~LT~Gliederung 9Title1~LT~Gliederung 8Title1~LT~Gliederung 9**@'A' 1'+''!''''''''%'$'*** * *Title1~LT~TitelTitle1~LT~Titel#''QQ**g*@'A'1'+''!''' ''''''%'$'************Title1~LT~UntertitelTitle1~LT~Untertitel#''QQ**g*@'A'1'+''!''' ''''''%'$'************Title1~LT~NotizenTitle1~LT~Notizen"''**g*@'A' 1'+''!'''''''''%'$'***** * ******Title1~LT~HintergrundobjekteTitle1~LT~Hintergrundobjekte+;(,,--..Title1~LT~HintergrundTitle1~LT~Hintergrund''''QQVV+'l2}H=< p W >H\d<^:m9lrV: " DrMd88JoeMp0>1:>1.:>1: ODrLy LAYER_LAYOUTDrLy LAYER_BCKGRNDDrLy LAYER_BACKGRNDOBJDrLyLAYER_CONTROLSDrLy!LAYER_MEASURELINESDrMP'JoeMjJ8cDrML DrOb<SVDr&qz! %DrOb<SVDr&(B %DrOb<SVDr&q+>z!QDrOb<SVDr&(+>BQDrXXgg iDefault~LT~GliederungDrMPU  JoeM8cjJDrML DrObSVDr&8cjJ*Default~LT~Hintergrund8cjJDrObSVDr&v8cjJVvDrObSVDr& 28ciJDefault 2KG 2 iJ8ciJ8c2 2 2 2DrObSVDr&8cjJDefaultTPM :2:2jJ8cjJ8cM M :2M :2DrObSVDr& 28cjJDefault 2KG 2 jJ8cjJ8c2 2 2 2DrObSVDr& sXXDefault KG  XsXXsX   DrObSVDr  2c]SDUDQ Default KG  2 2 :   DrObSVDr& 2 iJDefault 2B> iJ iJ n2 2 iJ iJDrObSVDr&v252Defaultv2KGv2v25252v2v2v2DrObSVDr&v2iJDefaultv2KGv2viJiJ|2v2v2v2DrXXDrObSVDr&_Y$Default~LT~Titel_Y}xV4B1hZ#Click to edit the title text formatDefault~LT~Titel<( (@'DrObySVDr& _%B+Default~LT~Gliederung 1 _%B xV4B1Z %Click to edit the outline text formatDefault~LT~Gliederung 1<( (@'Second Outline LevelDefault~LT~Gliederung 2 <( (@'Third Outline LevelDefault~LT~Gliederung 3 <( (@'Fourth Outline LevelDefault~LT~Gliederung 4<( (@'Fifth Outline LevelDefault~LT~Gliederung 5<( (@'Sixth Outline LevelDefault~LT~Gliederung 6<( (@'Seventh Outline LevelDefault~LT~Gliederung 7<( (@'Eighth Outline LevelDefault~LT~Gliederung 8<( (@'Ninth Outline LevelDefault~LT~Gliederung 9<(  ( DrXXDefaultgg aDefault~LT~GliederungDrMPJoeMjJ8cDrML DrObSVDr&K$Default~LT~TitelKqxV4B1\ZClick to move the slideDefault~LT~Titel<( (@'DrObSVDr&x.EZ&Default~LT~Notizenx.EZzxV4B1eZClick to edit the notes formatDefault~LT~Notizen<( (@'DrXXDefaultgg YDefault~LT~GliederungDrMP H JoeM8cjJDrML DrObSVDr&8cjJ) Title1~LT~Hintergrund8cjJDrOb(SVDr&v8cJvDrObSVDr&8cjJ Default]Y c Z =)=)OJ8cjJ8cc c c DrObSVDr& W)8ciJDefault W)KG W) iJ8ciJ8cW) W) W) W)DrObSVDr&v(>r)Defaultv(KGv(vr)>r)>(v(v(v(DrObSVDr& e]Default KG  e]e]   DrObSVDr&v(JDefaultv(KGv(vJJ)v(v(v(DrObSVDr  Jc]SDUDQ Default KG  J J    DrXXDrObSVDr& _'# Title1~LT~Titel _'|xV4B1gZ#Click to edit the title text formatTitle1~LT~Titel<( (@'DrOboSVDr&J\C*  Title1~LT~Gliederung 1 J\C xV4B1Z %Click to edit the outline text formatTitle1~LT~Gliederung 1<( (@'Second Outline LevelTitle1~LT~Gliederung 2 <( (@'Third Outline LevelTitle1~LT~Gliederung 3 <( (@'Fourth Outline LevelTitle1~LT~Gliederung 4<( (@'Fifth Outline LevelTitle1~LT~Gliederung 5<( (@'Sixth Outline LevelTitle1~LT~Gliederung 6<( (@'Seventh Outline LevelTitle1~LT~Gliederung 7<( (@'Eighth Outline LevelTitle1~LT~Gliederung 8<( (@'Ninth Outline LevelTitle1~LT~Gliederung 9<(  ( DrXXTitle1gg `Title1~LT~GliederungDrMPJoeM8cjJDrML DrObSVDr&x$Default~LT~TitelxqxV4B1\ZClick to move the slideDefault~LT~Titel<( (@'DrObSVDr&J#\(D& Default~LT~NotizenJ#\(DzxV4B1eZClick to edit the notes formatDefault~LT~Notizen<( (@'DrXXTitle1gg XTitle1~LT~GliederungDrPgcJoeMjJ8cDrML8DrMD,DrXXgg IDefault~LT~GliederungDrPgJJoeM8cjJDrML8DrMD,DrObSVDr& _'#  Title1~LT~Titel _'xV4B1ZNTAUGTitle1~LT~Titel<( (@'  DrOb[SVDr& *VT>(  Title1~LT~Untertitel *VT>xV4B1ZIntroduction in to use of SQLTitle1~LT~Untertitel<( (@'A'1' Peter DomineyTitle1~LT~Untertitel<( (@'A'1'   Title1~LT~Untertitel<( (@'A' 1'+'  Title1~LT~Untertitel<( (@'A' 1'+'  6Copyright Peter Dominey 2004, Title1~LT~Untertitel<( (@'A' 1'+'6666 6 6 6 6DrXXDrObtSVDr&8cjJ  Default8cjJNTAUGgg PTitle1~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPglJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1{xV4B1fZSQLDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1|Z Some HistoryDefault~LT~Gliederung 1<( (@'A'   DrXXDrObtSVDr&7ciJ  Default7ciJSQLgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgQJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1{xV4B1fZSQLDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1 _%ByxV4B1`Z Some HistoryDefault~LT~Gliederung 1<( (@'A'   *Grew out of IBMs System/R project in 1974Default~LT~Gliederung 2 <( (@'A' ***Default~LT~Gliederung 2 <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg!JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1{xV4B1fZSQLDefault~LT~Titel<( (@'DrObRSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1Z Some HistoryDefault~LT~Gliederung 1<( (@'A'   *Grew out of IBMs System/R project in 1974Default~LT~Gliederung 2 <( (@'A' ***UOriginally Structured English Query Language which is why we pronounce it sequel.Default~LT~Gliederung 2 <( (@'A' UUUDrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg3JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1{xV4B1fZSQLDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1z _%B[xV4B1@Z Some HistoryDefault~LT~Gliederung 1<( (@'A'   *Grew out of IBMs System/R project in 1974Default~LT~Gliederung 2 <( (@'A' ***UOriginally Structured English Query Language which is why we pronounce it sequel.Default~LT~Gliederung 2 <( (@'A' UUU.Oracle, in 1979 had SQL as its query languageDefault~LT~Gliederung 2 <( (@'A' ...DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgrJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1{xV4B1fZSQLDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1> _%BxV4B1Z Some HistoryDefault~LT~Gliederung 1<( (@'A'1'   *Grew out of IBMs System/R project in 1974Default~LT~Gliederung 2 <( (@'A' 1'***UOriginally Structured English Query Language which is why we pronounce it sequel.Default~LT~Gliederung 2 <( (@'A' 1'UUU.Oracle, in 1979 had SQL as its query languageDefault~LT~Gliederung 2 <( (@'A' 1'...GAfter DB2 arrived and SQL became accepted, ANSI/ISO standards developedDefault~LT~Gliederung 2 <( (@'A' 1'GGGDrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgcJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1nZ SQL Used inDefault~LT~Titel<( (@'   DrObSVDr& _&B+Default~LT~Gliederung 1 _&BxxV4B1cZClick to add an outlineDefault~LT~Gliederung 1<( (@'DrXXDrObtSVDr&7ciJ  Default7ciJ# SQL Used ingg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgcJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1nZ SQL Used inDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1dZOracleDefault~LT~Gliederung 1<( (@'A'SyBaseDefault~LT~Gliederung 1<( (@'A'DB2Default~LT~Gliederung 1<( (@'A' SQLServerDefault~LT~Gliederung 1<( (@'A'   MySQLDefault~LT~Gliederung 1<( (@'A'OthersDefault~LT~Gliederung 1<( (@'A'DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgMJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1oZ SQL OverviewDefault~LT~Titel<( (@'   DrObSVDr&_%B+ Default~LT~Gliederung 1_%B`xV4B1KZSQL is the standard database language for most commercial relational databases. It's wide acceptance stems from its ability to manage all of the necessary database manipulations while remaining relatively easy to learn.Default~LT~Gliederung 1<( (@'A'DrXXDrObtSVDr&7ciJ  Default7ciJ$ SQL Overviewgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1oZ SQL OverviewDefault~LT~Titel<( (@'   DrObSVDr&_%B+ Default~LT~Gliederung 1O_%B0xV4B1ZSQL is the standard database language for most commercial relational databases. It's wide acceptance stems from its ability to manage all of the necessary database manipulations while remaining relatively easy to learn.Default~LT~Gliederung 1<( (@'A'qEnglish-like command structure makes it readable, while providing for the most complex of database functionality.Default~LT~Gliederung 1<( (@'A'qqqDrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg4JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1oZ SQL OverviewDefault~LT~Titel<( (@'   DrObSVDr&_%B+ Default~LT~Gliederung 1r_%BSxV4B1:ZSQL is the standard database language for most commercial relational databases. It's wide acceptance stems from its ability to manage all of the necessary database manipulations while remaining relatively easy to learn.Default~LT~Gliederung 1<( (@'A' 1' qEnglish-like command structure makes it readable, while providing for the most complex of database functionality.Default~LT~Gliederung 1<( (@'A' 1' qqqqqqj40+ SQL statements follow the same basic structure, structural consistency keeps it easy to read and learnDefault~LT~Gliederung 1<( (@'A' 1' jjjjjjDrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrOb"SVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZAll statements start withDefault~LT~Gliederung 1<( (@'A'DrXXDrObtSVDr&7ciJ  Default7ciJ% SQL Structuregg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgbJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1$ _%BxV4B1ZAll statements start withDefault~LT~Gliederung 1<( (@'A'A verb, Default~LT~Gliederung 2 <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgLJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BjxV4B1QZAll statements start withDefault~LT~Gliederung 1<( (@'A'A verb, Default~LT~Gliederung 2 <( (@'A' selectDefault~LT~Gliederung 3 <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg[JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZAll statements start withDefault~LT~Gliederung 1<( (@'A'A verb, Default~LT~Gliederung 2 <( (@'A' SelectDefault~LT~Gliederung 3 <( (@'A' InsertDefault~LT~Gliederung 3 <( (@'A' DeleteDefault~LT~Gliederung 3 <( (@'A' UpdateDefault~LT~Gliederung 3 <( (@'A' Default~LT~Gliederung 3g* <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgfJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _zC+ Default~LT~Gliederung 1( _zC  xV4B1Z All statements start withDefault~LT~Gliederung 1<( (@'A'A verb, Default~LT~Gliederung 2 <( (@'A' SelectDefault~LT~Gliederung 3 <( (@'A' InsertDefault~LT~Gliederung 3 <( (@'A' DeleteDefault~LT~Gliederung 3 <( (@'A' UpdateDefault~LT~Gliederung 3 <( (@'A' .A list of tables and/or fields follow the verbDefault~LT~Gliederung 2 <( (@'A' ...Followed by a clause or clausesDefault~LT~Gliederung 2 <( (@'A' Default~LT~Gliederung 3g* <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1S _%B4xV4B1ZConsider the following:Default~LT~Gliederung 1<( (@'A'9SELECT job_name,machine FROM job WHERE machine=somenameDefault~LT~Gliederung 2 <( (@'A' 999DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K!DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgYJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZThe verb defines this as a SELECT statement, which retrieves rows from a table. We are selecting two columns, job_name and machine from the table, job.Default~LT~Gliederung 1<( (@'A' 1' ETwo clauses follow the SELECT statement with the keywords FROM and WHERE. The FROM clause selects the two columns from a table named job", while the WHERE clause includes the expression that we only want data from rows where the machine is somename. This query's result would be a list of jobs for the machine somename. Default~LT~Gliederung 1<( (@'A' 1' EEEEEEDrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K#DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg}JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZAnother example:Default~LT~Gliederung 1<( (@'A'BSELECT job_name FROM job WHERE machine=somename AND owner=rootDefault~LT~Gliederung 2 <( (@'A' BBBDefault~LT~Gliederung 2g* <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K%DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrOb8SVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZWe have here created a query that no only selects the jobs that are run on a particular machine (somename) but refined it to select only those that are run on that machine AND owned by the user rootDefault~LT~Gliederung 1<( (@'A'Default~LT~Gliederung 2g* <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K'DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgfJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1mZA further example:Default~LT~Gliederung 1<( (@'A'SELECT job_name FROM job WHERE machine=somename AND owner=fred AND command='/sybasedv/dbaroot/bin/do_dbcc.ksh -Dmaster -SAUTOSYS_SQL_DEV1'Default~LT~Gliederung 2 <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K)DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgeJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1' _%BxV4B1Z$This highlights two important pointsDefault~LT~Gliederung 1<( (@'A'$$$Default~LT~Gliederung 1<( (@'A'DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K+DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrOb-SVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1Z$This highlights two important pointsDefault~LT~Gliederung 1<( (@'A'$$$BThe any number of clauses can be appended to refine the statement Default~LT~Gliederung 2 <( (@'A' BBBDefault~LT~Gliederung 1<( (@'A'DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K-DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg_JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1! _%BxV4B1Z$This highlights two important pointsDefault~LT~Gliederung 1<( (@'A'$$$EThe any number of clauses can be appended to refine the statement andDefault~LT~Gliederung 2 <( (@'A' EEEVThe text can be included as fully as you wish, so long as it is enclosed in quotes Default~LT~Gliederung 2 <( (@'A' VVVDrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K/DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgOJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1pZ SQL StructureDefault~LT~Titel<( (@'   DrObSVDr& _-C+ Default~LT~Gliederung 1 _-CmxV4B1NZ$This highlights two important pointsDefault~LT~Gliederung 1<( (@'A'$$$EThe any number of clauses can be appended to refine the statement andDefault~LT~Gliederung 2 <( (@'A' EEEUThe text can be included as fully as you wish, so long as it is enclosed in quits Default~LT~Gliederung 2 <( (@'A' UUUIPlease note ignore MSs stupid quote marks, they are just single quotesDefault~LT~Gliederung 3 <( (@'A' IIIDefault~LT~Gliederung 1g* <( (@'A'Default~LT~Gliederung 3 <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K1DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg"JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1nZ SQL clausesDefault~LT~Titel<( (@'   DrObKSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZBThe extend and power of SQL lays in the clauses you can construct.Default~LT~Gliederung 1<( (@'A'BBBDrXXDrObtSVDr&7ciJ  Default7ciJ# SQL clausesgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K3DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1nZ SQL clausesDefault~LT~Titel<( (@'   DrObSVDr& _%B+ Default~LT~Gliederung 1N _%B/xV4B1ZBThe extend and power of SQL lays in the clauses you can construct.Default~LT~Gliederung 1<( (@'A'BBBTake the earlier statement: Default~LT~Gliederung 2 <( (@'A' SELECT job_name FROM job WHERE machine=somename AND owner=fred AND command='/sybasedv/dbaroot/bin/do_dbcc.ksh -Dmaster -SAUTOSYS_SQL_DEV1'Default~LT~Gliederung 3 <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K5DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg-JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1tZSQL LIKE clauseDefault~LT~Titel<( (@'DrObPSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZBThe extend and power of SQL lays in the clauses you can construct.Default~LT~Gliederung 1<( (@'A'  BBBBBBGTo make it find jobs that have similar commands we could have a state: Default~LT~Gliederung 2 <( (@'A'  GGGGGG\SELECT job_name FROM job WHERE machine=somename AND owner=fred AND command LIKE %dbcc%Default~LT~Gliederung 3 <( (@'A' \\\\ \ \UHere we are finding anything that has the string dbcc in it from the column commandDefault~LT~Gliederung 2 <( (@'A'  UUUUUU% is used as a wild card.Default~LT~Gliederung 2 <( (@'A'  DrXXDrObtSVDr&7ciJ  Default7ciJ-SQL ‘LIKE’ clausegg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K7DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgcJoeM8cjJDrML8DrMD,DrOb SVDr&_1$Default~LT~Titel_1xV4B1xZSQL DISTINCT clauseDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZBThe extend and power of SQL lays in the clauses you can construct.Default~LT~Gliederung 1<( (@'A'BBBYTo find all the machines that have jobs defined, but only list each unique machines name:Default~LT~Gliederung 2 <( (@'A' YYY SELECT DISTINCT machine FROM jobDefault~LT~Gliederung 3 <( (@'A'    DrXXDrObtSVDr&7ciJ  Default7ciJ1SQL ‘DISTINCT’ clausegg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K9DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrOb SVDr&_1$Default~LT~Titel_1xV4B1xZSQL DISTINCT clauseDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1xZBThe extend and power of SQL lays in the clauses you can construct.Default~LT~Gliederung 1<( (@'A'  BBBBBBYTo find all the machines that have jobs defined, but only list each unique machines name:Default~LT~Gliederung 2 <( (@'A'  YYYYYY SELECT DISTINCT machine FROM jobDefault~LT~Gliederung 3 <( (@'A'       0And then order it in a simple alphabetical orderDefault~LT~Gliederung 2 <( (@'A'  0000001SELECT DISTINCT machine FROM job ORDER BY machineDefault~LT~Gliederung 3 <( (@'A' 1111 1 1DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K;DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1uZSQL WHERE clauseDefault~LT~Titel<( (@'DrOb/SVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1Z&We touched earlier on the where clauseDefault~LT~Gliederung 1<( (@'A'&&&DrXXDrObtSVDr&7ciJ  Default7ciJ.SQL ‘WHERE’ clausegg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K=DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg4JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1uZSQL WHERE clauseDefault~LT~Titel<( (@'DrObVSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1Z&We touched earlier on the where clauseDefault~LT~Gliederung 1<( (@'A'&&&1SELECT job_name FROM job WHERE machine=somenameDefault~LT~Gliederung 2 <( (@'A' 1112And made the use of the simplest form, equals = Default~LT~Gliederung 2g* <( (@'A' 222DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&K?DrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1uZSQL WHERE clauseDefault~LT~Titel<( (@'DrOb=SVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1Z&We touched earlier on the where clauseDefault~LT~Gliederung 1<( (@'A'&&&1SELECT job_name FROM job WHERE machine=somenameDefault~LT~Gliederung 2 <( (@'A' 1115And made the use of the simplest form and equals = Default~LT~Gliederung 2g* <( (@'A' 555There are other operators:Default~LT~Gliederung 2g* <( (@'A' Default~LT~Gliederung 2g* <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KADrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg  JoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1uZSQL WHERE clauseDefault~LT~Titel<( (@'DrOb SVDr& _B+ Default~LT~Gliederung 1M  _B. xV4B1 Z&We touched earlier on the where clauseDefault~LT~Gliederung 1<( (@'A' 1'&&&& & &1SELECT job_name FROM job WHERE machine=somenameDefault~LT~Gliederung 2 <( (@'A' 1'111111Default~LT~Gliederung 2g*  <( (@'A' 1'5And made the use of the simplest form and equals = Default~LT~Gliederung 2g*  <( (@'A' 1'555555There are other operators:Default~LT~Gliederung 2g*  <( (@'A' 1'Default~LT~Gliederung 2g*  <( (@'A' 1' =Equal Default~LT~Gliederung 2 g*  <( (@'A' 1''       <>Not equal Default~LT~Gliederung 2 g*  <( (@'A' 1'' >Greater than Default~LT~Gliederung 2 g*  <( (@'A' 1'' =Greater than or equal Default~LT~Gliederung 2 g*  <( (@'A' 1'' <=Less than or equal Default~LT~Gliederung 2 g*  <( (@'A' 1'' %BETWEEN Between an inclusive range Default~LT~Gliederung 2 g*  <( (@'A' 1''%%%%%%  LIKESearch for a patternDefault~LT~Gliederung 2 g*  <( (@'A' 1'' Default~LT~Gliederung 2g*  <( (@'A' 1'DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KCDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1uZSQL WHERE clauseDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1S _%B4xV4B1Z6To extract information where you have a list of items:Default~LT~Gliederung 1<( (@'A'666OSELECT job_name FROM job WHERE machine IN (machine1,machinezxt,machine1b)Default~LT~Gliederung 2 <( (@'A' OOODefault~LT~Gliederung 2g* <( (@'A'  Default~LT~Gliederung 2g* <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KEDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPg7JoeM8cjJDrML8DrMD,DrOb SVDr&_1$Default~LT~Titel_1xV4B1{ZSQL Select within SelectDefault~LT~Titel<( (@'DrObSSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1ZJSELECT job_name FROM job WHERE machine IN (SELECT hostname FROM keymaster)Default~LT~Gliederung 1<( (@'A'JJJDrXXDrObtSVDr&7ciJ  Default7ciJ0SQL Select within Selectgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KGDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_Y$Default~LT~Titel_YxV4B1Z$SQL Information from multiple tablesDefault~LT~Titel<( (@'$$$DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BbxV4B1KZ Examine the following statement:Default~LT~Gliederung 1<( (@'A'   ^SELECT keymaster.hostid, job.job_name FROM keymaster, job WHERE job.machine=keymaster.hostnameDefault~LT~Gliederung 2 <( (@'A' ^^^DrXXDrObtSVDr&7ciJ  Default7ciJ<$SQL Information from multiple tablesgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KIDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1sZSQL IntroductionDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BxV4B1yZAs stated earlier, this was introduction to SQL and hopefully has provided a taste of the things that can be done to extract information directly from the AutoSys database.Default~LT~Gliederung 1<( (@'A'Default~LT~Gliederung 1<( (@'A'DrXXDrObtSVDr&7ciJ  Default7ciJ(SQL Introductiongg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KKDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrPgUJoeM8cjJDrML8DrMD,DrObSVDr&_1$Default~LT~Titel_1xV4B1sZSQL IntroductionDefault~LT~Titel<( (@'DrObSVDr& _%B+ Default~LT~Gliederung 1 _%BpxV4B1UZAs stated earlier, this was introduction to SQL and hopefully has provided a taste of the things that can be done to extract information directly from the AutoSys database.Default~LT~Gliederung 1<( (@'A'Default~LT~Gliederung 1<( (@'A'Default~LT~Gliederung 2 <( (@'A' Default~LT~Gliederung 2 <( (@'A' DrXXDrObtSVDr&7ciJ  Default7ciJgg QDefault~LT~GliederungDrPgJoeMjJ8cDrML8DrMD,DrOb<SVDr&KMDrObSVDr&x.EZ& Default~LT~Notizenx.EZnxV4B1YZClick to add notesDefault~LT~Notizen<( (@'DrXXgg YDefault~LT~GliederungDrXXGeneric PrinterSGENPRT`TlJobData 1 printer=Generic Printer orientation=Portrait copies=1 scale=1 margindajustment=-1,-1,-1,-1 colordepth=24 pslevel=0 colordevice=0 PPDContexData PageSize:Letter@@XFFDhB@̿ȺFF˺F˺FFFS@S@S@ B@̉@@`F؉@@`^PuF DrVwV SVDr SVDr:SVDrSVDrA LAYER_LAYOUT:SVDrSVDr#SVDr SVDr# SVDr0 SVDr1 SVDr3 SVDr4SVDr@SVDr SVDrD SVDrP SVDrQ DrHL DrHL DrHL $kqL Root Entry!r\V)䰱CompObjEOle persist elements" SfxDocumentInfo uBasicManager2 4StarBASICSfxWindowsStandardJSfxStyleSheetsySummaryInformation( DStarDrawDocument3$D=