Nick Upson wrote:

>does this do what you want?
>
>select first 1 C.Number, C.Name, A.Number, A.Name
>from Client C left outer join Animal A on A.Owner = C.Number
>

No this only fetches the first record from Client table. What I want is
to get records from Client table and ONLY ONE record from Animal table
if there is one for that client.

Regards

Sandeep