User/Groups

I am trying to populate a select box on a form with all users in the group
with the sysid of 1 using the following query:

SELECT usename FROM pg_user, pg_group WHERE pg_user.usesysid IN 
pg_group.grolist AND pg_group.grosysid = 1;

however, everytime I run it I recieve the following error:

ERROR:  parser: parse error at or near "pg_group"

which leads me to belive that the IN operator is not correct, is there
another one that I should be using?  Thanks in advance.

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio