Re: special join

On 07/09/2020 11:26, Jan Novak wrote:
> 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

order by....unique

-- 
When plunder becomes a way of life for a group of men in a society, over 
the course of time they create for themselves a legal system that 
authorizes it and a moral code that glorifies it.

  Frédéric Bastiat