JOIN Queries
This section provides information about the features and restrictions that are specific to how the CData JDBC Driver for 1010data supports joins.
The CData JDBC Driver for 1010data supports join queries between any tables in 1010Data. Tables in 1010Data do not contain relationship information. Instead, data can be joined between any two tables, but with some limitations. The only joins available are INNER and LEFT. All other join types will fail.
SELECT A.name, A.type, B.name, B.type FROM solar AS A INNER JOIN solar AS B ON A.name = B.orbits