home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / get_trail_last_mysql.sql < prev    next >
Encoding:
Text File  |  2003-09-19  |  294 b   |  13 lines
  1. # get the last trail
  2. SELECT trail.entry_id,
  3.        trail.trail_id as id,
  4.        trail.responsible,
  5.        trail.state
  6. FROM $PROJECT_trail trail, $PROJECT_trail trail0
  7. WHERE trail.entry_id IN ($ID)
  8.   AND trail0.entry_id=trail.entry_id
  9. GROUP BY
  10.   trail.trail_id
  11. HAVING id = MAX(trail0.trail_id)
  12.  
  13.