home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / test_assigned_mysql.sql < prev    next >
Encoding:
Text File  |  2004-08-13  |  251 b   |  11 lines
  1. # test currently assigned 
  2. SELECT
  3.   trail.trail_id as id
  4. FROM $PROJECT_trail trail, $PROJECT_trail trail0
  5. WHERE trail.entry_id=?
  6.   AND trail.responsible=?
  7.   AND trail0.entry_id=trail.entry_id
  8. GROUP BY
  9.   trail.trail_id
  10. HAVING id = MAX(trail0.trail_id)
  11.