Results 1 to 3 of 3

Thread: ANSI SQL support for joins

  1. 04-20-2003, 03:48 AM #1
    robinsoa
    robinsoa is offline Registered User
    Join Date
    Apr 2003
    Posts
    1

    ANSI SQL support for joins

    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
    Reply With Quote Reply With Quote
  2. 04-20-2003, 08:48 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Most databases support SQL-92 standard. The join types you mentioned are supported by all major databases like SQL Server 2000 and Oracle 9i.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  3. 04-20-2003, 09:42 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Here are some links where you can find about SQL 92 standards

    http://www.contrib.andrew.cmu.edu/~s...ql/sql1992.txt
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules