---
title: "Using SQL File with Markup - 9.x and earlier"
canonical: "https://support.appfire.com/space/SUPPORT/89138855/Using%20SQL%20File%20with%20Markup%20-%209.x%20and%20earlier"
format: markdown
---
# Scenario
> Macro (div)
>
> > Macro (inline-media-image)
>
> Estimated Time: 10** min**
In this scenario, let's insert the *SQL File* macro on a Confluence page by inserting [Markup](https://confluence.atlassian.com/doc/confluence-wiki-markup-251003035.html) from the menu. Our *SQL File* macro references a file containing SQL located within the ***/script*** (default) directory of your Confluence server.
## Background
Our scenario uses a data source profile, *BookWarehouse*, to query a database table, *BOOKS*. The table contains the following columns and rows:
```sql
SQL > select * from books;
+----+----------------------------+---------------------+-------+
| id | title | author | price |
+----+----------------------------+---------------------+-------+
| 1 | The Grapes of Wrath | John Steinbeck | 12.99 |
| 2 | Nineteen Eighty-Four | George Orwell | 8.99 |
| 3 | The Wind-Up Bird Chronicle | Haruki Murakami | 7.99 |
| 4 | Don Quixote | Miguel De Cervantes | 29.99 |
| 5 | Pilgrims Progress | John Bunyan | 17.99 |
| 6 | Robinson Crusoe | Daniel Defoe | 29.05 |
| 7 | Gullivers Travels | Jonathan Swift | 15.98 |
| 8 | Tom Jones | Henry Fielding | 13.59 |
| 9 | Clarissa | Samuel Richardson | 13.59 |
| 10 | Tristram Shandy | Laurence Sterne | 7.59 |
+----+----------------------------+---------------------+-------+
```
> ℹ️ For information about data source profiles, refer to:
> ℹ️
> ℹ️ - [Data source profiles](https://appfire.atlassian.net/wiki/spaces/SQL/pages/74323164/Configure+Data+Source+Profiles+-+9.x) for 9.x versions
> ℹ️ - [Data source profiles](https://appfire.atlassian.net/wiki/x/6xNuB) for 8.x versions
Our query is stored within a file called *books.sql* and along with our Confluence administrator to place it within the ***/script*** (default) directory on our Confluence server. Our query looks like:
```sql
SELECT title as "Title", author as "Author", price as "Retail Price" FROM books WHERE price < 30 ORDER BY title;
```
## Steps
The following steps demonstrates how to use Markup to insert the *SQL File* macro on a Confluence page:
> Macro (table-plus)
>
> | | | |
> | --- | --- | --- |
> |  | ## Create Confluence page
Create a Confluence page to add the *SQL File* macro needed to list out your books.
1. Create a page named*** Classic Books ***in a space accessible to the desired audience.
> 2. Click **Save** to save the new page. | |
> | --- |
> |  | ## Insert the *SQL File* macro using the Insert Markup Menu
Edit the *Classic Books* page and:
1. Select **Insert Markup** from the top menu.
> 2. Type the following into the editor window. Note the *dataSource* name and file name referenced:
> 3. Click **Insert** to insert your Markup within the page.
> 4. Click **Save **to save your page and view your results.
## Alternative:
> Macro (nested-table) | **How to insert Markup from the menu**
 |
## Explore Tutorials
We've prepared a number of [tutorials](https://appfire.atlassian.net/wiki/spaces/SQL/pages/74322767/Tutorials) which demonstrates how to use our *SQL* macros with the native *Chart* macro.