Hi, I'm having problems to make a query.
Situation: One table with data: JobID,Year,Week,Place,Name 1,2003,1,Place1,Person1 2,2003,1,Place2,Person2 3,2003,2,Place1,Person3 4,2003,2,Place2,Person4 5,2003,3,Place1,Person2 6,2003,3,Place2,Person6 7,2003,3,Place3,Person5 8,2003,4,Place1,Person1 9,2003,4,Place3,Person5 I want to query this table to get the following result: Year,Week,P1,N1,P2,N2,P3,N3,... 2003,1,Place1,Person1,Place2,Person2,, 2003,2,Place1,Person3,Place2,Person4,, 2003,3,Place1,Person2,Place2,Person6,Place3,Person5 2003,4,Place1,Person1,,,Place3,Person5 What should the select query be to achieve this?? Thanks --- [This E-mail is scanned for viruses by Declude Virus, this service is provided to you by Syscom nv (http://www.syscom.be)] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
