Take the table fruit:-

FrType  FrName  FrColour
-----------------------
PPepo   Gourd   Multi
Pepo    Melon   Yellow
Hesp    Lemon   Yellow
Hesp    Lime    Green
Hesp    Orange  Orange
True    Kiwi    Green
True    Guava   Green

SELECT FrName FROM fruit WHERE FrColour = 'Green';

Gives 3 rows:-

Lime
Kiwi
Guava

Is there any way of combining those result using SQL to give just 1 row:-

Lime,Kiwi,Guava

Charlie

Reply via email to