Re: SQL Syntax problem

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Cc: sad <sad(at)bankir(dot)ru>
Subject: Re: SQL Syntax problem
Date: 2003-09-30 07:52:51
Message-ID: 3F793653.3070300@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

sad wrote:

>>select ...
>>from auswahlkatalog k, anspruchkorrektur a, beteiligter b, v_betkorr f
>>where k.awk_id = a.awk_id and b.bet_id(+) = a.bet_idemp
>> and a.ask_id = f.ask_id(+)
>
>
> This (+) means JOIN

Means OUTER JOIN but I don't remember the side.

> e.g. (+)-marked equations used as a joining condition

Not exactly see above

Regards
Gaetano Mendola

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message pginfo 2003-09-30 10:23:55 Re: SQL Syntax problem
Previous Message sad 2003-09-30 05:22:06 Re: SQL Syntax problem