Re: special join

On Mon, 7 Sep 2020 12:26:14 +0200, Jan Novak <[email protected]>
wrote:

> 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.

What do you define as "first IP"?
A table is a set, all rows are equal, there is no pre-defined
order.

For more detailed answers, please post the schema of both tables
and example data.
-- 
Regards,
Kees Nuyt