Re: Problems in query

Поиск
Список
Период
Сортировка
От Masaru Sugawara
Тема Re: Problems in query
Дата
Msg-id 20020529204154.7872.RK73@sea.plala.or.jp
обсуждение исходный текст
Ответ на Problems in query  ("Denilson Guedes Duarte" <denilson@bnet.com.br>)
Ответы Complex join query  ("Gareth Kirwan" <gbjk@thermeoneurope.com>)
Re: Problems in query  (Masaru Sugawara <rk73@sea.plala.or.jp>)
Список pgsql-admin
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




В списке pgsql-admin по дате отправления:

Предыдущее
От: Bhuvan A
Дата:
Сообщение: Mirroring ENTIRE DATABASE.
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: how to install postgresql!!