home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / sql / get_assignment_person.sql < prev    next >
Encoding:
Text File  |  2003-03-25  |  114 b   |  7 lines
  1. # get all the projects that are assigned to a person
  2. SELECT
  3.   project_id
  4. FROM assignment
  5. WHERE person_id=?
  6.  
  7.