- ---
> NF 01 20 Company International denilson
>
> I used left join because the client it has none record in table username.
>
>
> - Original Message -
> From: "Masaru Sugawara" <[EMAIL PROTECTED]>
> To: "Denilson Guedes Duarte&q
On Sat, 25 May 2002 09:53:39 -0300
"Denilson Guedes Duarte" <[EMAIL PROTECTED]> 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 try to use a subqyuery:
> select
> (select u.username from ctareceber c left join
