Does anyone know what the standard SQL support for joins is. Are inner, left, right and outer joins all part of the standard?
Does anyone know of database servers that don't fully support joins?
TIA
Aaron
Printable View
Does anyone know what the standard SQL support for joins is. Are inner, left, right and outer joins all part of the standard?
Does anyone know of database servers that don't fully support joins?
TIA
Aaron
Most databases support SQL-92 standard. The join types you mentioned are supported by all major databases like SQL Server 2000 and Oracle 9i.
Here are some links where you can find about SQL 92 standards
http://www.contrib.andrew.cmu.edu/~s...ql/sql1992.txt