Multi-Key Database Join Issue - Row 1 And Row 2 Use The Same Database 关注

0
Avatar
Legacy Poster

Good afternoon,

 

I have 2 SQL databases that I am joining together.  I have done basic joins within Bartender before without issue.  This join is quite a bit more complicated as it requires 3 unique keys to match in order for it to be a valid join.  The premise of this is, I need to join database a to database b on a.cust_code = b.cust_code and a.cust_order= b.cust_order and a.UPC = b.UPC.  It is completely do-able in the SQL world but it is blowing up when I attempt to perform this logic within the multi-database join UI screen.  Attached is the screenshot of what is going on.  Is there an alternate/better way of achieving this?  I know I can make it work if I boil it down to a single key join, but unfortunately that cannot be done in this scenario.  Please see attached screenshot.

1 评论

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

For the sake of others looking at the same problem/solution it is BarTender: Error Message # 6220

 

This is for BarTender 9.3 SR1

Build 2715

请先登录再写评论。