ÿþ<html id="SyllabusShared"> <head> <!-- LRN Toolkit Version 01.00.0200.00 --> <META http-equiv="Content-Type" content="text/html; charset=utf-8"/> <base target="Content"></base> <!-- The Stylesheet that pretties everything up --> <link REL="stylesheet" TYPE="text/css" HREF="../Styles/CourseOutline.css"></link> <!-- find the constants --> <SCRIPT LANGUAGE="javascript" SRC="../Components/constants.js"></SCRIPT> <!-- Add the client side dynamic TOC behavior --> <SCRIPT LANGUAGE="javascript" SRC="../Components/SyllabusBehavior.js"></SCRIPT> <!-- This is a target node for transformation. It is CASE SENSISTIVE so don't change it --> <script language="javascript" for="window" event="onload">SyllabusShared.setAttribute("urlLearnLRN","..\\Components\\UIDManifest.XML");parent.SyllabusNav.Initialize();</script> <title id="ttl_Contents_Text">Table Of Contents</title> </head> <body id="syllabusBody"> <!-- DHTML from the xsl transformation goes here --> <div id="targetContainer" style="position:absolute; top:0; width:expression(syllabusBody.clientWidth); height:expression(syllabusBody.clientHeight); overflow:auto"> <div id="target"> <DIV> <table id="tblContent" border="0" cellpadding="0" cellspacing="0" height="100%" width="100%"> <tr> <td valign="top"> <DIV ID="SyllabusItems"> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="30" HREF="../../Intro.htm" FileID="Content1" ID="LRNID1" title="SQL">SQL </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="31"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="32" HREF="../../Lesson1.htm" FileID="Content2" ID="LRNID2" title="Lesson 1 What is SQL?">Lesson 1 What is SQL? </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="33" HREF="../../Lesson1.htm#1.1" FileID="Content3" ID="LRNID3" title="1.1 Relational Databases - Introduction">1.1 Relational Databases - Introduction </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="34" HREF="../../Lesson1.htm#1.2" FileID="Content4" ID="LRNID4" title="1.2 Standards">1.2 Standards </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="35" HREF="../../Lesson1.htm#1.3" FileID="Content5" ID="LRNID5" title="1.3 Tables">1.3 Tables </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="36" HREF="../../Lesson1.htm#1.4" FileID="Content6" ID="LRNID6" title="1.4 SQL">1.4 SQL </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="37" HREF="../../Lesson1.htm#1.5" FileID="Content7" ID="LRNID7" title="1.5 Course Databases">1.5 Course Databases </A> </DIV> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="38"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="39" HREF="../../Lesson2.htm" FileID="Content8" ID="LRNID8" title="Lesson 2 - The SELECT Statement">Lesson 2 - The SELECT Statement </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="40" HREF="../../Lesson2.htm#2.1" FileID="Content9" ID="LRNID9" title="2.1 Select Columns">2.1 Select Columns </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="41" HREF="../../Lesson2.htm#2.2" FileID="Content10" ID="LRNID10" title="2.2 The Where Clause">2.2 The Where Clause </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="42" HREF="../../Lesson2.htm#2.3" FileID="Content11" ID="LRNID11" title="2.3 Column Order">2.3 Column Order </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="43" HREF="../../Lesson2.htm#2.4" FileID="Content12" ID="LRNID12" title="2.4 Renaming Columns">2.4 Renaming Columns </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="44" HREF="../../Lesson2.htm#2.5" FileID="Content13" ID="LRNID13" title="2.5 ALL vs DISTINCT">2.5 ALL vs DISTINCT </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="45" HREF="../../Lesson2.htm#2.6" FileID="Content14" ID="LRNID14" title="2.6 Arithmetic Operators">2.6 Arithmetic Operators </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="46" HREF="../../Lesson2.htm#2.7" FileID="Content15" ID="LRNID15" title="2.7 Comparison Operators">2.7 Comparison Operators </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="47" HREF="../../Lesson2.htm#2.8" FileID="Content16" ID="LRNID16" title="2.8 Logical Operators">2.8 Logical Operators </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="48" HREF="../../Lesson2.htm#2.9" FileID="Content17" ID="LRNID17" title="2.9 Between">2.9 Between </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="49" HREF="../../Lesson2.htm#2.10" FileID="Content18" ID="LRNID18" title="2.10 IN and NOT IN">2.10 IN and NOT IN </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="50" HREF="../../Lesson2.htm#2.11" FileID="Content19" ID="LRNID19" title="2.11 LIKE - Pattern Matching">2.11 LIKE - Pattern Matching </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="51" HREF="../../Lesson2.htm#2.12" FileID="Content20" ID="LRNID20" title="2.12 NULL Values">2.12 NULL Values </A> </DIV> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="52"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="53" HREF="../../Lesson3.htm" FileID="Content21" ID="LRNID21" title="Lesson 3 - Sorting and Aggregate Functions">Lesson 3 - Sorting and Aggregate Functions </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="54" HREF="../../Lesson3.htm#3.1" FileID="Content22" ID="LRNID22" title="3.1 Sorting - Order By">3.1 Sorting - Order By </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="55" HREF="../../Lesson3.htm#3.2" FileID="Content23" ID="LRNID23" title="3.2 Aggregate Functions">3.2 Aggregate Functions </A> </DIV> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="56"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="57" HREF="../../Lesson4.htm" FileID="Content24" ID="LRNID24" title="Lesson 4 - Reporting and Grouping">Lesson 4 - Reporting and Grouping </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="58" HREF="../../Lesson4.htm#4.1" FileID="Content25" ID="LRNID25" title="4.1 Group By">4.1 Group By </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="59" HREF="../../Lesson4.htm#4.2" FileID="Content26" ID="LRNID26" title="4.2 Having">4.2 Having </A> </DIV> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="60"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="61" HREF="../../Lesson5.htm" FileID="Content27" ID="LRNID27" title="Lesson 5 - Delete, Insert, Update Statements">Lesson 5 - Delete, Insert, Update Statements </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="62" HREF="../../Lesson5.htm#5.1" FileID="Content28" ID="LRNID28" title="5.1 Insert">5.1 Insert </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="63" HREF="../../Lesson5.htm#5.2" FileID="Content29" ID="LRNID29" title="5.2 Update">5.2 Update </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="64" HREF="../../Lesson5.htm#5.3" FileID="Content30" ID="LRNID30" title="5.3 Delete">5.3 Delete </A> </DIV> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="65"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="66" HREF="../../Lesson6.htm" FileID="Content31" ID="LRNID31" title="Lesson 6 - Table Joins">Lesson 6 - Table Joins </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="67" HREF="../../Lesson6.htm#6.1" FileID="Content32" ID="LRNID32" title="6.1 Two Table Joins">6.1 Two Table Joins </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="68" HREF="../../Lesson6.htm#6.2" FileID="Content33" ID="LRNID33" title="6.2 Primarty and Foreign Keys">6.2 Primarty and Foreign Keys </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="69" HREF="../../Lesson6.htm#6.3" FileID="Content34" ID="LRNID34" title="6.3 Inner and Outer Joins">6.3 Inner and Outer Joins </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="70" HREF="../../Lesson6.htm#6.4" FileID="Content35" ID="LRNID35" title="6.4 The On Clause and Joins">6.4 The On Clause and Joins </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="71" HREF="../../Lesson6.htm#6.5" FileID="Content36" ID="LRNID36" title="6.5 Multi Table Joins">6.5 Multi Table Joins </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="72" HREF="../../Lesson6.htm#6.6" FileID="Content37" ID="LRNID37" title="6.6 Self Joins">6.6 Self Joins </A> </DIV> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="73"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="74" HREF="../../Lesson7.htm" FileID="Content38" ID="LRNID38" title="Lesson 7 - Sub Queries">Lesson 7 - Sub Queries </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="75" HREF="../../Lesson7.htm#7.1" FileID="Content39" ID="LRNID39" title="7.1 In and Not In">7.1 In and Not In </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="76" HREF="../../Lesson7.htm#7.2" FileID="Content40" ID="LRNID40" title="7.2 Comparison Operators">7.2 Comparison Operators </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="77" HREF="../../Lesson7.htm#7.3" FileID="Content41" ID="LRNID41" title="7.3 Any and All">7.3 Any and All </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="78" HREF="../../Lesson7.htm#7.4" FileID="Content42" ID="LRNID42" title="7.4 Group By and Having">7.4 Group By and Having </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="79" HREF="../../Lesson7.htm#7.5" FileID="Content43" ID="LRNID43" title="7.5 Exists">7.5 Exists </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="80" HREF="../../Lesson7.htm#7.6" FileID="Content44" ID="LRNID44" title="7.6 Correlated Subqueries">7.6 Correlated Subqueries </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="81" HREF="../../Lesson7.htm#7.7" FileID="Content45" ID="LRNID45" title="7.7 Nesting and Multiple Subqueries">7.7 Nesting and Multiple Subqueries </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/t_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="82" HREF="../../Lesson7.htm#7.8" FileID="Content46" ID="LRNID46" title="7.8 Subqueries vs Joins">7.8 Subqueries vs Joins </A> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/v_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="83" HREF="../../Lesson7.htm#7.9" FileID="Content47" ID="LRNID47" title="7.9 Subqueries in UPDATE, DELETE, INSERT">7.9 Subqueries in UPDATE, DELETE, INSERT </A> </DIV> </DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:block"> <SPAN CLASS="ContainerClosed" onkeydown="ContainerEnterClick(this)" onclick="ContainerClick(this)" onmouseover="this.style.cursor='hand'" tabindex="84"><img ALIGN="ABSMIDDLE" border="0" width="22" height="24" src="../Images/plus.gif"/> </SPAN> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="85" HREF="../../Lesson8.htm" FileID="Content48" ID="LRNID48" title="Lesson 8 - Views">Lesson 8 - Views </A> </DIV> <DIV> <DIV nowrap="true" CLASS="CocMrg" STYLE="display:none"> <img ALIGN="ABSMIDDLE" src="../Images/blank_space.gif" border="0" width="22" height="24"/> <img ALIGN="ABSMIDDLE" src="../Images/l_space.gif" border="0" width="22" height="24"/> <A Class="CocLnk" onclick="ItemClick(this)" tabindex="86" HREF="../../Lesson8.htm#8.1" FileID="Content49" ID="LRNID49" title="8.1 Problems with Views">8.1 Problems with Views </A> </DIV> </DIV> </DIV> </td> </tr> </table> </DIV></div> </div> </body> </html>