Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
WHERE, GROUP BY and HAVING difficulties over JOINS
SELECT c1.rId, q1.qId, q1.name, q1.level, q1.sublevel, c1.pId, p.name FROM ( ( candidates c1 INNER JOIN quals q1 USING ( qId ) ) INNER JOIN ( candidates c2 INNER JOIN quals q2 USING ( qId ) ) ON q1.level < q2.level ) INNER JOIN persons p ON p.pId = c1.pId WHERE q1.sublevel =1 GROUP BY c1.pId -->... -
WHERE, GROUP BY and HAVING difficulties over JOINS
Thanks. That link wasn't quite what I was looking for but I followed the link to "3.6.4. The Rows Holding the Group-wise Maximum of a Certain Field", where I used one of suggestions in the comments and did a self-join on the joined candidates and quals tables to find the min instance for each... -
WHERE, GROUP BY and HAVING difficulties over JOINS
Hi, I'm having some difficulties with the following... I have a table of persons (pId, name), one of qualifications (qId, name, level, sublevel) and a table of candidates (cId, qId, pId, date). The candidates table links the persons and qualifications tables. The qualifications have a level...
