Subject Re: [firebird-support] Problem with sql
Author Sandeep Chandra
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.