Get value from a column where another column equals another

[SacredFootball]

Confusing question?

The only way I can explain it best is to show it:

Table1
---------------------------
Name    Num1   Num2   Num3
Devin   224    18     845
Scott   322    32     652
Jim     179    46     929
Tim     202    41     562

Query Getting Max Value
---------------------------
Num1    Num2    Num3
322     46      929

I need to write a query to get the name of each of the highest values. It should look something like this:

Pseudo code:

SELECT [NAME] WHERE TABLE1.[NUM1] = QUERY.[NUM1]

My code as it stands now:

SELECT TABLE1.NAME
FROM TABLE1, [QUERY]
WHERE (("TABLE1.NUM1"="QUERY.NUM1"));

Does this make any sense? Is there a better way to do this?