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.