Does TSQL support natural and EQUI joins?

• michael.leach2015

  SSCommitted

  Points: 1597

  More actions

  January 13, 2020 at 10:54 pm

  #3715098

  I am trying to find some information on this, but it seems like TSQL doesn't support natural joins and EQUI joins.  Is this true?

• Michael L John

  One Orange Chip

  Points: 27038

  More actions

  January 14, 2020 at 3:59 pm

  #3715276

  An equi join is simply a subset of a join.  The criteria is an equality operator, as I understand things.

  A natural join is an extension of PL-SQL, MySQL, and maybe a couple others.  T-SQL does not support this syntax.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/