This section provides information about the features and restrictions that are specific to how the CData Power BI Connector for 1010data supports joins. The CData Power BI Connector 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