home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / get_description_mysql.sql < prev    next >
Encoding:
Text File  |  2003-10-12  |  247 b   |  8 lines
  1. # get the initial description
  2. SELECT trail.entry_id,
  3.        trail.detail
  4. FROM $PROJECT_trail trail
  5. LEFT JOIN $PROJECT_trail t2
  6.   ON (t2.entry_id = trail.entry_id AND t2.trail_id<trail.trail_id)
  7. WHERE t2.trail_id IS NULL
  8. AND trail.entry_id IN ($ID)