From: Jean-Luc Lachance <jllachan@nsd.ca>
To: Frank Morton <fmorton@base2inc.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: join question
Date: Fri, 18 Oct 2002 15:50:56 -0400
Message-ID: <3DB06620.39193D92@nsd.ca> (raw)
References: <F53s0dt2NCF6TMlz9K90000565d@hotmail.com>
<027d01c276d8$504a1100$8455e5ce@edison>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jllachan@nsd.ca, fmorton@base2inc.com
Subject: Re: join question
In-Reply-To: <3DB06620.39193D92@nsd.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox