Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 42B27475E8A
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 15:50:08 -0400 (EDT)
Received: from beamish.nsd.ca (unknown [205.150.156.194])
	by postgresql.org (Postfix) with ESMTP id 0A984475B8E
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 15:50:07 -0400 (EDT)
Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id PAA21522;
	Fri, 18 Oct 2002 15:50:06 -0400
X-Authentication-Warning: beamish.nsd.ca: smap set sender to <jllachan@nsd.ca>
	using -f
Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap
	(V2.1/2.1+anti-relay+anti-spam)
	id xma021520; Fri, 18 Oct 02 15:50:04 -0400
Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148])
	by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id PAA29092;
	Fri, 18 Oct 2002 15:49:35 -0400
Message-ID: <3DB06620.39193D92@nsd.ca>
Date: Fri, 18 Oct 2002 15:50:56 -0400
From: Jean-Luc Lachance <jllachan@nsd.ca>
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Frank Morton <fmorton@base2inc.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: join question
References: <F53s0dt2NCF6TMlz9K90000565d@hotmail.com>
	<027d01c276d8$504a1100$8455e5ce@edison>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/247
X-Sequence-Number: 9964

I think you meant:

select profile.name
from profile,attribute
where ( profile.id = attribute.containerId)
  and ( profile.state =' 1020811' or ( attribute.name = 'marketsegment'
and attribute.value = '1020704');


> select profile.name from profile,attribute where
> ((profile.state='1020811') or ((attribute.name='marketsegment') and
> (attribute.value='1020704') and (profile.id=attribute.containerId)));
> 
> Why doesn't this last query return just one row?
> 
> TIA
>