Hi I have the following problem: I have a database with two fields "projectid" and "partner". Here some data: Projectid / Partner 1 / A1 2 / A2 2 / B2 3 / A3 3 / B3 3 / C3 4 / A1 4 / B4 ...
I want to number the partners for every project, e.g. Projectid / Partner / Partnernumber 1 / A1/1 2 / A2 /1 2 / B2 /2 3 / A3 /1 3 / B3 /2 3 / C3 /3 4 / A1 /1 4 / B4 /2 ... I tried several queries but I am lost. Any ideas? Thanks Renger _________________________________________________ ECOPLAN Forschung und Beratung in Wirtschaft und Politik Economic Research and Policy Consultancy Thunstrasse 22 / CH-3005 Berne (Switzerland) Phone: +41 31 356 61 61 / Fax: +41 31 356 61 60 mailto:[EMAIL PROTECTED] / http://www.ecoplan.ch> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]