Can INNER JOIN syntax be used with Oracle?

[jasonbair]

I would like to write an application that can be used with either Oracle or SQL Server (and only write my SQL statements one time). I cannot find the definitive answer to my question:

Is there a way to use 'inner join' syntax with Oracle?

(Please note--I'm familiar with Oracle-style inner and outer joins, but for the sake of this question, assume that I do NOT want to use them--I'm interested specifically in 'inner join' syntax.)

Thanks!

 

[carp]

I haven't looked it up, but I believe this is NOT supported in Oracle prior to 9i. However, I read an article about 9i that specifically mentioned the INNER JOIN syntax, so I think this is a new feature.

 

[Tim1]

Hi Jason,

If you use the *= join syntax, I do believe that both Oracle and SQL server (and indeed most RDBMS) will support that as a outer join.

HTH

Tim