home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / test_author_group.sql < prev    next >
Encoding:
Text File  |  2004-08-02  |  163 b   |  9 lines
  1. # test original author group
  2. SELECT
  3.   count(*)
  4. FROM $PROJECT_entry issue, person
  5. WHERE
  6.   issue.entry_id=?
  7. AND issue.author=person.username
  8. AND person.group_code=?
  9.