Re: return records with more than one occurrences

Howdy, Tarsis.

Please try this out.

SELECT a.id, id_table1,a.name
FROM "Table2" a
NATURAL JOIN 
(SELECT id_table1
"Table2" 
GROUP BY id_table1
HAVING COUNT(*) > 1) b

Tell me if it worked or not, and if it didn't the errors/uncorrect results.

Best,
Oliveiros

----- Original Message ----- 
From: "Tarsis Lima" <tarsis.lima@gmail.com>
To: <pgsql-sql@postgresql.org>
Sent: Wednesday, January 05, 2011 2:18 PM
Subject: [SQL] return records with more than one occurrences


> how would the SELECT to  return only records with more than one
> occurrences  of id_table1? example:
> -- Table1
> -- id --
> -------------------------
>    1
>    2
> 
> 
> -- Table2
>   id  --- | id_table1 | name
>  ----------------------------------------------
>   4  ---- | -----  1 ------ |   Tom
>   5  ---- | -----  1 ------ |   Luci
>   6  ---- | -----  2 ------ |  Cleber   ------>this can not return
> 
> 
> 
> 
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql