LEFT JOIN 2

[stigejg]

Hi,

I am sitting here with big troube to run LEFT join on mu sql-script and woundering if here is some problem with my database or sqø*+?????

SELECT a.pnr, m.kpnr, b.fname, b.lname
FROM (person a LEFT JOIN marrage m ON a.pnr = m.kpnr) LEFT JOIN person b ON m.mpnr = b.pnr;

This is a simple script, but will not run on my database, does anyone se something wrong here.

This select-sentence runs perfectly on ms access.

I will be pleased with any hints of what's wrong here.

regard Stig

 

[lfoata]

I believe that syntax is not supported by oracle.
Try something like the following syntax:
SELECT *
FROM a,b
Where a.Col1 (+)= b.Col2;

 

[sem]

As far as I know Oracle does not support JOIN syntax (at least now). For outer joins (+) is used.

 

[stigejg]

Thanks folks,

For a moment I got a litle doubt on my knowledge in sql, but no I am back in busines again.

Stig