[selwonk]

Ok folks - thanks for that. I'll give it a go and report back

Thank you

--------------- Added at 12:12 ---------------

Thanks chaps - that gave me what I needed. The resultant query looks like this:

SELECT
	reputation.postid,
	reputation.userid,
	reputation.whoadded,
	reputation.reason,
	user.username,
	userwho.username AS usernamefrom

FROM
	reputation

INNER JOIN
	(user INNER JOIN user AS userwho ON reputation.userid=user.userid) ON reputation.whoadded=userwho.userid

WHERE
	reputation.reputation >= 1 AND
	reputation.reason <> ''

ORDER BY
	reputation.dateline DESC
LIMIT 10;

Thanks again!