home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / sql / get_assignment.sql < prev    next >
Encoding:
Text File  |  2003-01-21  |  221 b   |  12 lines
  1. # get the assignment relation
  2. SELECT
  3.   assignment.person_id,
  4.   project_area,
  5.   area_order,
  6.   username
  7. FROM assignment, person
  8. WHERE project_id=?
  9.   AND assignment.person_id=person.person_id
  10. ORDER BY area_order
  11.  
  12.