| From: | "Bt" <jacky(at)xtrapower(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | table linking problem |
| Date: | 2002-10-04 16:35:00 |
| Message-ID: | ankfrn$iib$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I have two table, follow :
content
content_id | material_id | percentage
-----------------------------------------------------
1 1 100%
2 2 63.5%
2 3 31.5%
2 4 5%
material
material_id | name
------------------------------------------
1 COTTON
2 POLYESTER
3 NYLON
4 SPANDEX
The Question is,
How can I get like this :
100% COTTON
63.5% POLYESTER 31.5% NYLON 5% SPANDEX
Can I return the string like this ?
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paesold | 2002-10-04 16:38:21 | Re: Large databases, performance |
| Previous Message | Hans-Jürgen Schönig | 2002-10-04 16:30:47 | Re: [HACKERS] Large databases, performance |