SQL and Excell tables joining problem 关注
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.
3 评论

Bilal Aslam
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
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
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.
请先登录再写评论。