Re: SELECT syntax question - combining COUNT and DISTINCT - Mailing list pgsql-novice

On Wed, 1 Oct 2003 17:26:55 +1000, Cath Lawrence
<Cath.Lawrence@anu.edu.au> wrote:
>"SELECT DISTINCT chain_id FROM chain WHERE pdb_id IN (SELECT pdb_code
>FROM pdb_entry WHERE chain_count=1);"
>This looks OK but takes apparently forever

SELECT DISTINCT c.chain_id
  FROM chain AS c, pdb_entry AS p
 WHERE c.pdb_id = p.pdb_code
   AND p.chain_count = 1;

Servus
 Manfred