From: Mark Mikulec <mm98au@badger.ac.brocku.ca>
To: pgsql-sql@postgresql.org
Subject: Sequential select queries...??
Date: Tue, 14 Aug 2001 20:40:50 -0400
Message-ID: <3B79C512.9F6E09B7@badger.ac.brocku.ca> (raw)
Hello,
At first I thought what I was trying to do was simple and could be done
easily - but alas, I've spent way too much time and could not figure out
how to get the results in question.
Let's say I have a table T comprised of id of type integer, name and
description both of type text.
What i'd like to do is the following:
Select id from T where name = 'bleh';
and
Select id from T where description = 'bleh';
and result both results in the same result set. That is, duplicate id's
if they appear. So then I could do a GROUP BY and a COUNT to see how
many appeared in only one, and how many appeared in both.
Could someone help me? I've tried countless different sql queries, can't
seem to get one to work. If I can just get those duplicate id's in the
query.. then I'd be laughing and then I can complete my task.
Thanks in advance,
Mark
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: mm98au@badger.ac.brocku.ca
Subject: Re: Sequential select queries...??
In-Reply-To: <3B79C512.9F6E09B7@badger.ac.brocku.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