# Dataset$query

### Dataset$<mark style="color:purple;">query</mark>(*query\_string*) → [Query](https://docs.redivis.com/api/client-libraries/redivis-r/reference/query)

Execute a SQL query scoped to a particular dataset. Table names do not need to be fully qualified, since all tables are assumed to be within the dataset.

### **Parameters:**

**`query_string` :&#x20;*****str*** \
The SQL query to execute. Must follow the [Redivis SQL query syntax](https://docs.redivis.com/reference/projects/transform-nodes/raw-sql).

### **Returns:**

[**Query**](https://docs.redivis.com/api/client-libraries/redivis-r/reference/query)

### Examples

```r
dataset <- redivis$organization("Demo")$dataset("CMS 2014 Medicare Data")

query = dataset$query("
    SELECT 
        hospice_providers.name, 
        inpatient_charges.drg_definition
    -- The tables inpatient_chargers, hospice_providers are assumed to be 
    -- within the scoped dataset
    FROM inpatient_charges
    INNER JOIN hospice_providers 
        ON hospice_providers.provider_id = inpatient_charges.provider_id
")

print(query$to_tibble())
```