special join

Hi,

i have a table "server" with auto_increment field ID and a table "ip", 
with a filed "SERVER_ID" corrosponding to "server.ID"

select ip.VALUE as "ip" from server, ip where server.DELETED=0 and 
server.ID=ip.SERVER_ID

If in "ip" table for the server are more then one ip adress are saved, i 
get in my results the server also more then one time listed.

My question is: how can i get only the server with the first IP from the 
ip Table, if more then one ip's saved there.

Jan