Re: dynamic no of columns

2004-01-18 Thread Tobias Asplund
On Sun, 18 Jan 2004, Nitin Mehta wrote: > I need to select a column's value as different columns and other fields grouped by > those values. > > I want to select distinct values of reseller column as individual columns and other > data grouped on these values. Since the approach of tables usual

dynamic no of columns

2004-01-18 Thread Nitin Mehta
Hi everybody, I dont know, if it's been asked before, I was looking for the syntax to fetch dynamic no of column, which are actually the record values. I dont know, if it's possible with mysql as it doesn't yet provide sub-query feature (prod ver). I need to select a column's value as differen