Adding an option to sequel results

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

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.

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

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

Works perfectly! Thank you :slight_smile:

1 Like