I've just added a field that requires users to input a numerical value only and want to sort this to show the highest number first. The field is called 'field14' in the table and I've got a Sql query
Code:
SELECT userid,field14 FROM `vb_userfield` WHERE 1
ORDER BY field14 desc
Which works well, but instead of showing userid I want to show the username from vb_user table. Does anyone know of a query I can use to run this?