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 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
