This is a feature that currently only available in the hosted version of Redash. We do plan to open source it, but currently no ETA.
Update 22/2/2018: the ability to run queries on query results (which allows joining data across multiple data sources) is available in the open source version since V3.