JDBC Driver for Snowflake

Build 23.0.8839

JOIN Queries

The driver supports the complete join syntax in Snowflake. Snowflake supports inner joins, outer joins, and cross joins. The default is inner. Multiple join operations are supported.

SELECT field_1 [..., field_n] FROM
   table_1 [[AS] alias_1]
 [[INNER|[FULL|RIGHT|LEFT] OUTER|CROSS] JOIN
   table_2 [[AS] alias_2]
  [ON join_condition_1 [... AND join_condition_n]]
 ]+
 

Note that the default join is an inner join. The following limitations exist on joins in Snowflake:

  • Cross joins must not contain an ON clause.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839