Printing all data in group by?

[cheeyim]

Hie,

I was just wondering how you can print all data in one row after using group by function? This is my query

select variety
from grape_variety natural join wine_variety natural join wine
where wine.wine_id = 1
group by wine.wine_id;

The output is: Sparkling

But the output I desire is: Sparkling Red

If I do not put group by clause, it'll print the Sparkling and Red in seperate rows though

Thanks!

[trexx]

please post the structure of your database table and some of the data it contains.