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