DD Class11

esse quam videri
Revision as of 04:06, 10 April 2007 by Jeff (talk | contribs)
Jump to: navigation, search


Sub Query

Course adder example

http://iam.colum.edu/dd/classsource/class8/student.aspx

SQL Subquery

<sql>SELECT CourseID, CourseName, CourseNumber FROM Course WHERE ( 

  CourseID not in 
  (
     SELECT CourseID FROM StudentsCourses_vw WHERE StudentID = @StudentID
  )

) </sql>

Retrieved from "http://imamp.colum.edu/mediawiki/index.php?title=DD_Class11&oldid=5639"