# Adding an option to sequel results

**URL:** <https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169>\
**Category:** Ignition\
**Created:** [August 5, 2019, 3:39pm UTC](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169 "2019-08-05T15:39:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ammermanbrittanyf](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\
**Post date:** [August 5, 2019, 3:39pm UTC](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169/1 "2019-08-05T15:39:39Z")

</div>

I am currently using this SQL Query to populate a drop down in ignition.

```auto
SELECT DISTINCT VLAN FROM FA_ECA_MASTER ORDER BY VLAN ASC

```

I was wondering if it was possible to add another row to the results. I have a few options of VLANs but want to give the “All” option.  
Thanks.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 5, 2019, 3:43pm UTC](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169/2 "2019-08-05T15:43:15Z")

</div>

> [@ammermanbrittanyf](#):
>
> `SELECT DISTINCT VLAN FROM FA_ECA_MASTER ORDER BY VLAN ASC`

The simplest option is to just add a UNION clause. Exact syntax may vary depending on your DB flavor, but basically:

```sql
SELECT DISTINCT VLAN FROM FA_ECA_MASTER ORDER BY VLAN ASC
UNION
SELECT 'All'

```

---

<div class="post-metadata">

**Author:** ![ammermanbrittanyf](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\
**Post date:** [August 5, 2019, 3:46pm UTC](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169/3 "2019-08-05T15:46:11Z")

</div>

Works perfectly! Thank you 🙂