home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / sql / get_access.sql < prev    next >
Encoding:
Text File  |  2003-01-21  |  221 b   |  11 lines

  1. # get the access relation based on project_id
  2. SELECT
  3.   accesscode.person_id,
  4.   access_code,
  5.   username,
  6.   fullname,
  7.   email
  8. FROM accesscode, person
  9. WHERE project_id=?
  10.   AND accesscode.person_id=person.person_id
  11.