| From: | Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)jp> |
|---|---|
| To: | "Denilson Guedes Duarte" <denilson(at)bnet(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Problems in query |
| Date: | 2002-05-29 12:17:26 |
| Message-ID: | 20020529204154.7872.RK73@sea.plala.or.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, 25 May 2002 09:53:39 -0300
"Denilson Guedes Duarte" <denilson(at)bnet(dot)com(dot)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 try to 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Fankhauser | 2002-05-29 12:23:14 | Re: how to install postgresql!! |
| Previous Message | Bhuvan A | 2002-05-29 07:24:48 | Mirroring ENTIRE DATABASE. |