any pointer in this querying will be helpful looks complicated to me : a table has users from different states who used different methods to approach the application the table has userids (1,2,3,4,5,6..14000) approaches(a,b,c,d,e,f) states (wa,vic..) now i need to formulate a table which would have columns with coulmn 1 approaches and remaining column names with  states names westernaustralia, victoria, SA,queensland etc.  the approach row would have total no of people who used this approach in different states victoria 5 wa 0.. in the same way other 5 approaches would have number of people used the approach in different states(in columns). Hope I made it clear..