SQL and Excell tables joining problem 关注

0
Avatar
Bilal Aslam

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 评论
0
Avatar
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 

 

0
Avatar
Pete Thane
评论操作 固定链接

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
Avatar
Bilal Aslam
评论操作 固定链接

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.

 

请先登录再写评论。