Re: [newbie] Relations...

From: "John Moo" <projects(at)bitnet-nospam(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [newbie] Relations...
Date: 2001-06-05 21:50:15
Message-ID: 9fjk4h$eal$1@news.tpi.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Jerzy Kut" <jerzyk(at)inquad(dot)com> wrote in message
news:9fjjen$2p3p$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> Hi!
> I don't know if i understand of your problem but i think You try to do
> natural join on referenced attributes from both tables. Case explained
by
> You looks like cross join. Try to do:
>
> SELECT name,title,body,date FROM accounts,news WHERE author=login;
>
> All should works fine.
>
> But sorry if i give trivial solution - maybe i don't understand...
>
> Best regards.
>
> Jerzy Kut

That's it !
Thanks a lot !

PS. It's good to be stuipid after all ;)

John Moo

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-06-05 21:53:01 optimizer hints?
Previous Message Manuel Sugawara 2001-06-05 21:39:55 Re: Current database name