Hello all, I've a table like this :
site_1 pkg_name_1 version site_1 pkg_name_2 version site_1 pkg_name_3 version ... site_1 pkg_name_n version site_2 pkg_name_1 version site_2 pkg_name_2 version ... site_2 pkg_name_n version ... site_n pkg_name_1 version ... site_n pkg_name_n version And i would like to make a sql statement to obtain a result like this ; |pkg | site_1 | site_2 | site_3 ... site_n |------------------------------------------------------ |pkg_name_1 | version | version | version ... version |pkg_name_2 | version | version | version ... version |pkg_name_3 | version | version | version ... version |... |pkg_name_n | version | version | version ... version I really don't know how to write this sql request, even if there is one way to do it... I still hope someone will have an idea. Thank's for you help -- Vincent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]