SQL query help

[Nutz]

Hi,
Can some one help me with a sql query:

[SQL]$SQL = "SELECT * FROM " .TABLE_PREFIX ."imgtools";[/SQL]

That query works fine and goes on to a while statement listing all the userid's in the table ("imgtools")
But I would also like the query to get the actual usernames for each userid.
Any help would be much appreciated I?m at a loss of how to do it with out a query for every userid.

Many Thanks
Mat