# Vision power table

**URL:** <https://forum.inductiveautomation.com/t/vision-power-table/65267>\
**Category:** Ignition\
**Tags:** ignition80, vision\
**Created:** [October 17, 2022, 5:15am UTC](https://forum.inductiveautomation.com/t/vision-power-table/65267 "2022-10-17T05:15:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vani161998](https://avatars.discourse-cdn.com/v4/letter/v/ee7513/32.png) [@vani161998](https://forum.inductiveautomation.com/u/vani161998)\
**Post date:** [October 17, 2022, 5:15am UTC](https://forum.inductiveautomation.com/t/vision-power-table/65267/1 "2022-10-17T05:15:53Z")

</div>

hi guys,  
i have an required related to power table.  
i need two columns in a power table one need to be updated from database(using select query)  
and other columns needs to be a dropdown data which contains data from another database table.

the objective is to map both the columns.

below image for reference.

 ![Screenshot (29)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/c/bcfcf248ae0cd10dd2857fe49220916363a14d45.png)

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [October 17, 2022, 5:59am UTC](https://forum.inductiveautomation.com/t/vision-power-table/65267/2 "2022-10-17T05:59:14Z")

</div>

For the query that populates the table, simply add a blank column using `null as` or `'' as` in your SELECT statement.  
MySQL Example:  
`SELECT `ID`, '' as `DropDown` from some_Schema.some_Table`

Then, populate your blank drop down column using a select statement in the configureEditor extension function.  
Here is an example:

> [@How to query Database Table to populate Power Table Drop Down List within cell](https://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614/6):
>
> This article helped us accomplish our goal using Power Table Cell drop Down List.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d7d5e7da925f3a32a28d311e3efd0b62b8c3f0b.png)