Power BI Connector for Quandl

Build 20.0.7587

JOIN Queries

The CData Power BI Connector for Quandl supports standard SQL joins like the following examples.

Inner Join

An inner join selects only rows from both tables that match the join condition:

SELECT a.Close ac, g.Close gc FROM AAPL a, GOOGL g WHERE a.Date = '6/27/2016 12:00:00 AM' AND g.Date = '6/27/2016 12:00:00 AM'

Left Join

A left join selects all rows in the FROM table and only matching rows in the JOIN table:

SELECT a.Open, a.Close, g.Open, g.Close FROM AAPL a LEFT OUTER JOIN GOOGL g ON a.Date=g.Date

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587