Re: query concatenate

Ciao Eugenio,

On Fri, Mar 01, 2013 at 11:53:17AM +0000, Eugenio Trumpy wrote:
> ho provato con join ma mi si replicano troppe volte le row.Qualcuno ha suggerimenti?

potresti provare con

SELECT *
FROM t1
LEFT JOIN t2 ON t1.key = t2.key
LEFT JOIN t3 ON t1.key = t3.key
ORDER BY t1.key;

che a me dà il seguente output:

key | f1 | f2 | f3 | key | f4 | f5 | key | f6 | f7
-----+----+----+----+-----+-----+-----+-----+----+----
1 | a | b | c | | | | 1 | t | v
2 | d | e | f | 2 | oo | pp | 2 | v | z
2 | d | e | f | 2 | ooo | ppp | 2 | v | z
2 | d | e | f | 2 | o | p | 2 | v | z
3 | g | h | i | 3 | r | s | 3 | j | k
4 | l | m | n | | | | | |
(6 righe)

Saluti,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gianni(dot)ciolli(at)2ndquadrant(dot)it | www.2ndquadrant.it