Joins (version 6.5)

ANSI-standard join clauses are supported and include:

• JOIN
• CROSS JOIN
• INNER JOIN
• LEFT OUTER JOIN
• RIGHT OUTER JOIN
• FULL OUTER JOIN

Earlier versions of SQL Server joins continue to be supported although they will be discontinued in a future release.

For more information about implementing joins, SELECT Statement.