table linking problem
| От | ¼B¤tºÆ |
|---|---|
| Тема | table linking problem |
| Дата | |
| Msg-id | ankfrn$iib$1@news.hub.org обсуждение исходный текст |
| Ответы |
Re: table linking problem
Re: table linking problem Re: table linking problem |
| Список | 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.
В списке pgsql-general по дате отправления: