Hi
I need a help in SQL,There is table called sales.Its contains the day,sales quantity.If I write sql like below
select day,Sales_quantity from Sales.
Then result should be
Day SalesQuantity
Monday 20
Monday 302
Monday 50
Tuseday 30
etc..
The problem is I want to get result like below
Day SalesQuantity
Monday 20,302,50
Tuesday 30
There should be ',' sign between two values.How Do I write this kind of SQL.
Thanks
Tank50