ADO.NET Provider for Presto

Build 24.0.9060

JOIN Queries

The provider supports the complete join syntax in Presto. Presto 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 [EACH]
   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 Presto:

  • Cross joins must not contain an ON clause.

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