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.