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