# Table question (SQL)

**URL:** <https://forum.inductiveautomation.com/t/table-question-sql/15494>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [September 28, 2017, 1:02pm UTC](https://forum.inductiveautomation.com/t/table-question-sql/15494 "2017-09-28T13:02:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lyhkch](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lyhkch/32/9381_2.png) [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\
**Post date:** [September 28, 2017, 1:02pm UTC](https://forum.inductiveautomation.com/t/table-question-sql/15494/1 "2017-09-28T13:02:27Z")

</div>

In a table, the left side is a fixed column, can not change, the right is the corresponding data, the data can be obtained from the database query data,How to achieve ?

---

<div class="post-metadata">

**Author:** ![brandon1](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\
**Post date:** [September 28, 2017, 3:10pm UTC](https://forum.inductiveautomation.com/t/table-question-sql/15494/2 "2017-09-28T15:10:06Z")

</div>

You would need to create a custom property on your table to hold the result of the database query, and then append that data, possibly on a property change event, to your data property that drives the table.