Postgres Pro
Downloads
Home   >   mailing lists

Re: FROM + JOIN when more than one table in FROM - Mailing list pgsql-general

From Scott Marlowe
Subject Re: FROM + JOIN when more than one table in FROM
Date
Msg-id dcc563d10803122133g37cfd294k241decb9a0028253@mail.gmail.com
Whole thread Raw
In response to Re: FROM + JOIN when more than one table in FROM  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view 
On Wed, Mar 12, 2008 at 4:48 AM, Ivan Sergio Borgonovo
<mail@webthatworks.it> wrote:

>  one of the inner join doesn't have an on relationship.
>
>  As you could see in the other (longer) query I'm just trying to put in
>  the same row what would be

Could you get what you want by cross joining the first two tables?

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Can't rename an existnig DB because it doesn't exist???
Next
From: "Scott Marlowe"
Date:
Subject: Re: Column Statistics - How to dertermine for whole database