Originally posted by vishal sood
yes this may be the problem. Because on windows OS we r having Oracle 9i(9.2.0) and on Linux we r having oracle 8i.(8.1.7).

and on windows Os the same query is working fine.
"JOIN" is avialable only in 9.x.x onwards...