Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8Q342h09582 for ; Tue, 25 Sep 2001 23:04:02 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8Q317M89593 for pgsql-sql@postgresql.org; Tue, 25 Sep 2001 23:01:07 -0400 (EDT) (envelope-from news) From: nospam4@pobox.com (Ross Smith) X-Newsgroups: mailing.database.mysql, comp.databases.postgresql.sql, microsoft.public.sqlserver.server Subject: A simple join question that may stump you Date: 25 Sep 2001 20:01:06 -0700 Organization: http://groups.google.com/ Lines: 32 Message-ID: <89c01029.0109251901.3dcb5d77@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200109/237 X-Sequence-Number: 4919 OK, I have 2 tables, table A: ID FLAG ----- ----- 1 1 2 1 2 2 3 1 3 2 3 3 and table B: FLAG ----- 1 2 I want to find all id's from table A that have every flag in table B but no extra flags. So, I'd end up with: ID ----- 2 As id 2 has both flag 1 and flag 2, id 1 doesn't have flag 2, and id 3 has flag 3. I know it can be done, 'cause I've done it in the past, but I've spent hours on this to no avail. Surfing the net proved fruitless as well. Any help would be greatly appreciated.