Re: [newbie] Relations...

Поиск
Список
Период
Сортировка
От John Moo
Тема Re: [newbie] Relations...
Дата
Msg-id 9fjk4h$eal$1@news.tpi.pl
обсуждение исходный текст
Ответ на [newbie] Relations...  ("John Moo" <projects@bitnet-nospam.pl>)
Список 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 по дате отправления:

Предыдущее
От: alla@sergey.com (Alla)
Дата:
Сообщение: Function returning record
Следующее
От: lobet_romuald@my-deja.com (Romuald Lobet)
Дата:
Сообщение: Re: What CASE tools and clients for Postgres?