Hi Doris,
In oracle (+) is left outer join or right outer join .
You need to write:
select...
fromauswahlkatalog k, beteiligter b left outer join anspruchkorrektur a
on(b.bet_id = a.bet_idemp) left outer join v_betkorr f on (a.ask_id = f.ask_id)
where k.awk_id = a.awk
sad wrote:
select...
fromauswahlkatalog 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.
> 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...
>
This kind of conditions are left or right joins, depending on which side of the equal sign you have the (+).
Something like this
select ...
from
auswahlkatalog k,
INNER JOIN anspruchkorrektur a ON (k.awk_id = a.awk_id),
LEFT JOIN beteiligter b ON (b.bet_id = a.bet_idemp),
RIGHT JOI
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
Hi all,
I am moving the database from sybase to postgresql.Iam having problem
replacing the following similar syntax from sybase to postgres sql could
anybody help me out? It doesnt seem to recognize the '?' operator though it
works fine in Sybase.
select * from version where version_nr =?;
ER
