# SQL query WHERE column = property value (string)

**URL:** <https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794>\
**Category:** Ignition\
**Created:** [September 24, 2018, 10:36pm UTC](https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794 "2018-09-24T22:36:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dion.botha](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\
**Post date:** [September 24, 2018, 10:36pm UTC](https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794/1 "2018-09-24T22:36:25Z")

</div>

Hi guys,

Can someone tell me why I can execute this SQL query:

> SELECT vsf\_grades.designator  
> FROM vsf\_products INNER JOIN (vsf\_grades INNER JOIN vsf\_grade\_products ON vsf\_grades.db\_id = vsf\_grade\_products.vsf\_grades\_db\_id) ON vsf\_products.db\_id = vsf\_grade\_products.vsf\_products\_db\_id  
> WHERE (((vsf\_products.designator)='product1'));

And not this one:

> SELECT vsf\_grades.designator  
> FROM vsf\_products INNER JOIN (vsf\_grades INNER JOIN vsf\_grade\_products ON vsf\_grades.db\_id = vsf\_grade\_products.vsf\_grades\_db\_id) ON vsf\_products.db\_id = vsf\_grade\_products.vsf\_products\_db\_id  
> WHERE (((vsf\_products.designator)={Root Container.Dropdown 3.selectedStringValue}));

btw {Root Container.Dropdown 3.selectedStringValue} = 'product1'

Regards,

D.Botha

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 24, 2018, 10:37pm UTC](https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794/2 "2018-09-24T22:37:41Z")

</div>

Add the quotes outside the curly braces.