# Select Query Binding Question

**URL:** <https://forum.inductiveautomation.com/t/select-query-binding-question/9564>\
**Category:** Ignition\
**Created:** [January 19, 2015, 1:59pm UTC](https://forum.inductiveautomation.com/t/select-query-binding-question/9564 "2015-01-19T13:59:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Don\_t\_shoot](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\
**Post date:** [January 19, 2015, 1:59pm UTC](https://forum.inductiveautomation.com/t/select-query-binding-question/9564/1 "2015-01-19T13:59:57Z")

</div>

I want to binding a query to the component’s data , but in the select query I used different database’s table ,but the different database are setup in one Mysql software as the picture ,and I used the select query and also selected a defult database , but the error said “the table is not exist” as the picture ,how can I binding the select query which used different database’s tables ？  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2be9c056164b77eb77e30b4370cc97b95fc4b741.png)

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4e98d8f452f1a544b15c62ec7ca8b5fe29713a15.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [January 19, 2015, 7:15pm UTC](https://forum.inductiveautomation.com/t/select-query-binding-question/9564/2 "2015-01-19T19:15:00Z")

</div>

Just a quick look at the pic, it appears to have a space in the name after the period.

Sometimes copying and pasting the error into your thread can be a help. 😉

---

<div class="post-metadata">

**Author:** ![Don\_t\_shoot](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\
**Post date:** [January 20, 2015, 6:04am UTC](https://forum.inductiveautomation.com/t/select-query-binding-question/9564/3 "2015-01-20T06:04:10Z")

</div>

Thanks Jordan, the attachment are the entire sql query ,and the error , is there anything wrong ,and is that possible in a sql select query binding to use different database table in the query from the “database connection” ?

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b37b8344430d36d6fcc787aae7e2f5198c0ac86c.png)  
  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/50e16d61681dcbead8921ed0e6b532b27c6c463e.png)

---

<div class="post-metadata">

**Author:** ![george](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/george/32/14066_2.png) [@george](https://forum.inductiveautomation.com/u/george)\
**Post date:** [January 20, 2015, 12:06pm UTC](https://forum.inductiveautomation.com/t/select-query-binding-question/9564/4 "2015-01-20T12:06:30Z")

</div>

Look at the query that is displayed in the error message screen. It is a completely different query to what you’ve posted, i.e. the query you’ve posted is not the one giving the error.

The query with the error is referencing defect\_log rather than ign\_mes.defect\_log

Do you know what is running that query - have you got a component called Yield on the screen?

---

<div class="post-metadata">

**Author:** ![Don\_t\_shoot](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\
**Post date:** [January 21, 2015, 3:11am UTC](https://forum.inductiveautomation.com/t/select-query-binding-question/9564/5 "2015-01-21T03:11:43Z")

</div>

Sorry guys , there is a yield exsist actually ,and I changed database connection ,error is gone , thanks Jordan & george , I 'm a rookie 😆