Thanks to Stephan and Hubert for their replies. Using your answers I
was able to solve the problem. It turned out that its a natural join
that I wanted.
Thanks for quick help,
Ashutosh
On Sun, Sep 28, 2008 at 10:18, Stephan Szabo
<[EMAIL PROTECTED]> wrote:
> On Sun, 28 Sep 2008, Ashutosh Chauhan
On Sun, Sep 28, 2008 at 12:52:56AM -0400, Ashutosh Chauhan wrote:
> select a,b
> from (billing.item JOIN (
> select *
> from ( billing.invoice JOIN billing.customer
> on (id_customer_shipped =
> cust
On Sun, 28 Sep 2008, Ashutosh Chauhan wrote:
> Hi all,
>
> This has been asked before and answered as well.
> http://archives.postgresql.org/pgsql-sql/2007-12/msg2.php but I
> still cant figure out why postgres throws this error message even when
> I have provided the aliases. My query:
>
> se
Hi all,
This has been asked before and answered as well.
http://archives.postgresql.org/pgsql-sql/2007-12/msg2.php but I
still cant figure out why postgres throws this error message even when
I have provided the aliases. My query:
select a,b
from (billing.item JOIN (
