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, Ashutos
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 (
