My friend in Zimbabwe sent me an email a day ago with the following contents suppose i have a table called week_days with only 3 fields i.e. SEQUENCE DAY SALES as follows: SEQUENCE DAY SALES 1 Sun 23 2 Mon 18 3 Tue 30 4 Wed 15 5 Thu 20 6 Fri 08 7 Sat 0 i need a query that converts DAY column to a header row and sort by SEQUENCE as follows: DAY Sun Mon Tue Wed Thu Fri Sat SALES 23 18 30 15 20 08 0 Pliz Help!!!!!!!! I was like’ this looks like a candidate for pivot, but it requires that the result...