Re: sort problem

ok here we go: Table 1 user_table id points Table 2 reports report_id user_id rating The goal is to associate every user extra 50 points if he has a top 10 report. Top 10 report means the 10 reports with the highest ranking. This value is always changing, thats why I did not include it to the other points. Now that we have the users with the additional points we could add them to the total points of the user and then find out the 5 users with the highest total points. Thats the theory, but how to achieve this in real live?? Thanx for any idas, Andy "Analysis & Solutions" <danielc@analysisandsolutions.com> schrieb im Newsbeitrag news:20020711043907.GA21354@panix.com... > Please post the relevant table and field names. > > --Dan > > -- > PHP classes that make web design easier > SQL Solution | Layout Solution | Form Solution > sqlsolution.info | layoutsolution.info | formsolution.info > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409