Re: Problems in query

On Sat, 25 May 2002 09:53:39 -0300
"Denilson Guedes Duarte" <denilson@bnet.com.br> wrote:


> and runs ok, but the problem is that the table username (alias u) hane N records and I want to get only one record. I
tryto use a subqyuery: 
> select ....
> (select u.username from ctareceber c left join username u on u.id=c.cod_cliente limit 1) as fldusername
> .....
> in this case the query run ok, but I lose the left join property.
>
> How I can to do run with left join and get only one record in the other table (username u) ?
>


I'm not sure what the problems is.
Could you show us the output of the result you hope ?


Regards,
Masaru Sugawara