ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  SQL Subqueries
Subject:   subqueries
Date:   2003-05-15 11:32:27
From:   anonymous2
how do you do a subquery where you are using a composite primary key for example:


select courseID, studentID
from whatever
where courseID AND? StudentID IN (
select courseID, studentID
from somewhereelse
);


1 to 2 of 2
  1. subqueries
    2008-12-30 00:50:08  my pages [View]

  2. subqueries
    2003-06-26 07:54:31  anonymous2 [View]

1 to 2 of 2