5 years ago, I worked with an Oracle 7 server, and I absolutely positive that the "LEFT [OUTER] JOIN" was supported. In fact, there was even a recommandation to not use the older syntax ".. *=<nobr> <wbr></nobr>..". And about the MSSQL, I use on a daily basis the "LEFT [OUTER] JOIN" syntax on MSSQL7 and MSSQL2000 servers. It works (and it is not on the joints that we can critisize MSSQL<nobr> <wbr></nobr>... ).
Then, you must know that there is others free db servers. I use Firebird 1.0, and for little applications, SQLite. They are SQL92 compliant at 98 to 100% and works pretty well.
(sorry for the english, me not good<nobr> <wbr></nobr>;) )
Learn about Linux
Download Linux
Get Linux help
outer join & other free db
Posted by: edomaur on September 16, 2002 09:28 PM5 years ago, I worked with an Oracle 7 server, and I absolutely positive that the "LEFT [OUTER] JOIN" was supported. In fact, there was even a recommandation to not use the older syntax ".. *=<nobr> <wbr></nobr>..". And about the MSSQL, I use on a daily basis the "LEFT [OUTER] JOIN" syntax on MSSQL7 and MSSQL2000 servers. It works (and it is not on the joints that we can critisize MSSQL<nobr> <wbr></nobr>... ).
Then, you must know that there is others free db servers. I use Firebird 1.0, and for little applications, SQLite. They are SQL92 compliant at 98 to 100% and works pretty well.
(sorry for the english, me not good<nobr> <wbr></nobr>;) )
#