# Query across a Google Sheet and a CSV file

### Introduction

When working with data it's likely that you will have the need to query across a couple of different sources. In this example, we will show you how to do this with a Google Sheet and a CSV file.

```
SELECT d.Symbol, c.Security, c.Executive, d.Price FROM (SELECT a.Symbol as Symbol, a.Security as Security, b.Executive as Executive
FROM "https://raw.githubusercontent.com/dylanroy/sandp500-dataset/main/data.csv" a 
JOIN "https://raw.githubusercontent.com/dylanroy/ceo-dataset/main/data.csv" b ON a.Security = b.Company) c
JOIN "https://docs.google.com/spreadsheets/d/1u0RkdS8KBwvCvSSIiS-xCN-P1RAfhgNRVewysHGIOrg" d ON c.Symbol = d.Symbol
```

A sample Query using public example datasets that can be tested in the demo interface [here](https://www.usesql.com/demo) or the OpenAPI documentation [here](https://usesql.com/docs).

To See a more complex example with a more simple query please see the tutorial linked below.

{% content-ref url="show-external-query-results-in-a-google-sheet" %}
[show-external-query-results-in-a-google-sheet](https://docs.usesql.com/tutorials/show-external-query-results-in-a-google-sheet)
{% endcontent-ref %}