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