My Main table looks like this
FlowerID Red Yellow Orange Violet
01 ---------1-----0-------0-------0--
02 ---------1-----0-------1-------0--
03 ---------0-----0-------1-------0--
04 ---------1-----1-------1-------0--
05 ---------0-----0-------0-------1--
I need to retrive some thing like this, by a select query
FlowerID Colors NumberOfColors
01--------Red----------------1
02--------Red, Orange--------2
03--------Orange-------------1
04--------Red, Yellow---------2
05--------Violet-------------- 1
In this select query both Switch function and count function should be used to gether. But I dont know how to do it. Pls help,
Or is there any other ways?
I'm new 2 querues, Need you kind help,
Thanx 4 reading my post.