Excel Add-In for Presto

Build 24.0.9060

JOIN Queries

The add-in 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