hi

i'd try to ask in the most simple manner...

i've a table named 'first' which contains these field:

user | name | points

and second table named 'second' which contain these field

user | title |



my question is, I want to select all fields in table 'second' and sort them based on the value of column 'points' from table1.. how do I do it?

btw i'm trying to use PHP to do this... but I asked in the database forum since I think it's mostly a mysql issue..

thanks in advance