Re: FROM + JOIN when more than one table in FROM

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FROM + JOIN when more than one table in FROM
Date: 2008-03-13 04:33:38
Message-ID: dcc563d10803122133g37cfd294k241decb9a0028253@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 12, 2008 at 4:48 AM, Ivan Sergio Borgonovo
<mail(at)webthatworks(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-03-13 04:40:28 Re: Column Statistics - How to dertermine for whole database
Previous Message Scott Marlowe 2008-03-13 04:30:57 Re: Can't rename an existnig DB because it doesn't exist???