How to display multiple rows in 1 row

From: Baxter Allen <baxter(dot)allen(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to display multiple rows in 1 row
Date: 2017-01-10 19:55:07
Message-ID: CAEO6znEtU5ai7K9PqJjeQxjbBpgfn-8=w8QHQmh9L7FHFkamRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I have a database with a large number of individuals, and for each of these
individuals there are entries in multiple tables as follows:

table_a
_id individual
1.table_b 1
2.table_b 2
3.table_b 3
1.table_c 1
2.table_c 2
3.table_c 3
table_b
_id valA valB
1.table_b 1 2
2.table_b 4 7
3.table_b 5 4
table_c
_id valC valD
1.table_c 4 3
2.table_c 3 4
3.table_c 2 21
Using the following code:
Select distinct C.individual, A.*, B.*
FROM table_a A
LEFT JOIN table_b B ON A._id = B._id
LEFT JOIN table_c C ON A._id = C._id
order by A.individual

I get the following output:
individual _id valA valB _id valC valD
1 1.table_b 1 2
1 1.table_c 4 3
2 2.table_b 4 7
2 2.table_c 3 4
3 3.table_b 5 4
3 3.table_c 2 21
Instead, I would like the output for each individual to be all on a single
row:
individual _id valA valB _id valC valD
1 1.table_b 1 2 1.table_c 4 3
2 2.table_b 4 7 2.table_c 3 4
3 3.table_b 5 4 3.table_c 2 21
Any idea how I could make that happen?

Thanks!

Baxter

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2017-01-10 20:24:12 Re: How to display multiple rows in 1 row
Previous Message Rob Sargent 2017-01-09 15:54:00 Re: How to use external java libraries in Database