home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / get_assignment_person.sql < prev    next >
Encoding:
Text File  |  2004-06-16  |  108 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.