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