Re: [newbie] Relations... - Mailing list pgsql-general

From John Moo
Subject Re: [newbie] Relations...
Date
Msg-id 9fjk4h$eal$1@news.tpi.pl
Whole thread Raw
In response to [newbie] Relations...  ("John Moo" <projects@bitnet-nospam.pl>)
List pgsql-general
"Jerzy Kut" <jerzyk@inquad.com> wrote in message
news:9fjjen$2p3p$1@news.tht.net...
> 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


pgsql-general by date:

Previous
From: alla@sergey.com (Alla)
Date:
Subject: Function returning record
Next
From: lobet_romuald@my-deja.com (Romuald Lobet)
Date:
Subject: Re: What CASE tools and clients for Postgres?