Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id TAA14710 for ; Mon, 3 Apr 2000 19:03:51 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id QAA22392; Mon, 3 Apr 2000 16:07:17 -0700 From: "tjk@tksoft.com" Message-Id: <200004032307.QAA22392@uno.tksoft.com> Subject: Re: User/Groups To: mfork@toledolink.com (Michael Fork) Date: Mon, 3 Apr 2000 16:07:16 -0700 (PDT) Cc: pgsql-sql@postgresql.org In-Reply-To: from "Michael Fork" at Apr 3, 0 05:21:53 pm Content-Type: text X-Archive-Number: 200004/24 Michael, The IN operator should precede a sub query. E.g. SELECT usename FROM pg_user, pg_group WHERE pg_group.grosysid = 1 and pg_user.usesysid IN (select usesysid from pg_group); This probably doesn't do what you want. The example is just to demonstrate the point. Troy > > 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 > >