2.1.2.66 F401, Extended joined table

V0102

The specification states the following:

 Subclause 7.7, "<joined table>":
  
 <joined table> ::=
 <cross join>
 | <qualified join>
 | <natural join>
  
 <cross join> ::=
 <table reference> CROSS JOIN <table factor>
 ...
  
 <natural join> ::=
 { <table reference> | <partitioned join table> }
 NATURAL [ <join type> ] JOIN
 { <table factor> | <partitioned join table> }
  
 ...
  
 <join type> ::=
 INNER
 | <outer join type> [ OUTER ]
  
 <outer join type> ::=
 LEFT
 | RIGHT
 | FULL
  
 ...
  
 Conformance Rules
  
 Without Feature F401, "Extended joined table", conforming SQL language shall not contain a <cross join>.
  
 Without Feature F401, "Extended joined table", conforming SQL language shall not contain a <natural join>.
  
 Without Feature F401, "Extended joined table", conforming SQL language shall not contain FULL.
  

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature.