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 по дате отправления: