SQL and Excell tables joining problem

bilal aslm

• December 31, 2019 13:49

Hello,
We trying to populate a label from SQL and  excell.

Problem is coming out when we add both database and get joing two tables togheter, BArtender show us only excell colum with single tables and not the sql ones.to"JOIN" both tables as show below in the picture, Not having both tables joined we cannot proceed our label, we ask help to the forum if someone of you had this issue and how it hase been solved.

Thanks in advance and happy new year to all.

 

0

• 

  bilal aslm

  ★ BarTender Hero ★

  • January 02, 2020 17:29
  • Edited

  I noted that whenever i use SQL custom statment, it doesn't show both tables to join!

  is there any solution to this ?

  Thanks in advance 

   

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • January 03, 2020 00:31

  If you are using a custom SQL statement then you need to add the join and and any filter/query (WHERE) statements to it manually too. 

  If you have to use a Custom statement then set up the joins and filters without the custom stuff first and then go to the SQL Statement screen and copy the automatic statement that was created and then tick the option to create a custom statement and paste in the automatic statement and amend this by adding your custom settings  

  0
• 

  bilal aslm

  ★ BarTender Hero ★

  • January 04, 2020 07:43

  Hello Peter,

  Thanks for your suggestion and quick help, i would consult my IT, beacuse not so familiar with the queries in SQL, i think it would take ages to me to follow your instructions, i thought it was something simple in settings which was not working form me.

  Anyway thanks for your help.

   

  0

Please sign in to leave a comment.