Difference between revisions of "DD Class11"

Revision as of 04:06, 10 April 2007

Course adder example

SQL Subquery

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

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

) </sql>

@@ Line 1: / Line 1: @@
 [[Category:Data Design]]
+==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>