Re: [SQL] SQL Syntax problem

[Franco Bruno Borghesi]

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 JOIN v_betkorr f ON (a.ask_id = f.ask_id)

should give you the same results.

On Sun, 2003-09-28 at 09:43, Doris Bernloehr wrote:

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

signature.asc
Description: This is a digitally signed message part