Re: table linking problem

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.