Q:

Select Max in a table to get name in other table SQL

I have 2 tables 
Players 
Pnr
Pname
Padress
Pcity

Tickets 
Tnr
Pnr
Date
Costs

I want to get the name of the player with the highest Ticket Cost from the database with Select. And I want to know who has got a Ticket in May. I also want to know who has never got a Ticket.
How do I get each of these?
Pnr is the primary key of Players and is connected with Pnr from Tickets
I've tried 
SELECT MAX(Costs) from Players, Tickets
Where max()

A:

I hope i understand correctly. Try the following query. I think it will still have some errors, but you can comment them here and I will try to correct them.
 select top 1 Pname from Players 
    inner join Tickets on Players.Pnr = Tickets.Pnr
    where Date > 1.05.2014 and Date <31.05.2014
    order desc by Tickets.Costs

