Re: table linking problem
От | Shridhar Daithankar |
---|---|
Тема | Re: table linking problem |
Дата | |
Msg-id | 3DA1DEDE.6030.1067C81A@localhost обсуждение исходный текст |
Ответ на | table linking problem ("¼B¤tºÆ" <jacky@xtrapower.net>) |
Список | pgsql-general |
On 5 Oct 2002 at 0:35, XBXtXX wrote: > 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 select a.percentage,b.name from content a, material b where a.material_id=b.material_id; HTH Bye Shridhar -- kern, v.: 1. To pack type together as tightly as the kernels on an ear of corn. 2. In parts of Brooklyn and Queens, N.Y., a small, metal object used as part of the monetary system.
В списке pgsql-general по дате отправления: