- ---
> 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
I have this query:
select c.cod_cliente, c.controle, c.dt_vencimento,
c.dt_emissao, c.nro_doc_banco, c.nro_documento, c.recebido, c.ref_cidade,
c.valor, (select u.username from ctareceber c left join username u on
u.id=c.cod_cliente limit 1) as fldusername, p.id, p.nome, a.id, a.nome fro
