home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / sql / get_all_persons.sql < prev    next >
Encoding:
Text File  |  2003-04-17  |  170 b   |  13 lines
  1. # get all persons
  2. SELECT
  3.   group_code, 
  4.   person_id,
  5.   username,
  6.   password,
  7.   fullname,
  8.   email,
  9.   default_project
  10. FROM person
  11. WHERE
  12.   group_code <> 'admin'
  13.