SQL Syntax problem

From: Doris Bernloehr <bedo7(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL Syntax problem
Date: 2003-09-28 13:11:46
Message-ID: 200309281511.46427.bedo7@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello.

I've got a problem in porting the following select statement from Oracle to
Postgres, because of the characters after "b.bet_id" and "f.ask_id" in the
where clause: (+)
I don't know what these characters mean and how I can transform these into
PostgreSql Syntax.

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(+);

Hoping for help.
Doris

Browse pgsql-novice by date

  From Date Subject
Next Message Doris Bernloehr 2003-09-28 13:18:02 SQL Syntax problem
Previous Message Josh Berkus 2003-09-27 20:24:42 Re: Views and confidentiality