Two Databases Join? 关注

0
Avatar
Legacy Poster

Hi,

 

We have two databases with each different structure.

 

The first database contains address information (company, address, etc) , the second database contains products.

 

what i would like is to use both databases in bartender but i need somehow to join them. Of course not a problem, but these two databases do not contain the same columns. How can i join two databases when the actual column names differ in types of data?

 

We are using bartender automation latest version.

7 评论

0
Avatar
Legacy Poster
评论操作 固定链接

you can't join databases if their isn't a common column, it doesn't need to be the exact same name in each table, just the same piece of data.

0
Avatar
Legacy Poster
评论操作 固定链接

Understandable but how would you use then a label which has product information from database 1 and address information from database 2? Bartender forces me to join those databases but they are completely different in data.

0
Avatar
Legacy Poster
评论操作 固定链接

i got this one solved by using vb scripting from some other example on the forum. Thanks!

0
Avatar
Legacy Poster
评论操作 固定链接

Tom V, can you point me to that example?  I'm having a similar problem, needing to use a list of month codes and a separate list of year codes.

Thank you very much!

-Dan

0
Avatar
Legacy Poster
评论操作 固定链接

Sent you a PM with more details. 

 

BR Tom

0
Avatar
Legacy Poster
评论操作 固定链接

Hi,

 

I have the same problem, that I have different databases without common columns. How can I avoid the "necessary" joins?

 

Thanks,

Konrad

0
Avatar
Legacy Poster
评论操作 固定链接

You need to have a common column in your database. The only way to make it work when your database has no common column is by using vb scripting to refer to your database OR add a common column in your current databases. Good luck.

请先登录再写评论。