Nirmalya,

 

Offhand, the Oracle syntax is LEFT OUTER JOIN.
Next, in the clause after the FROM on line 6,  I think you need a SELECT to start that clause.

Silly me, I thought Oracle was ANSI compliant. Whose ANSI syntax is this?

 

Dennis Williams