Joining on multiple columns when creating a join against 2 tables
Hello,
At runtime, I’d like to join this text file with a table in our MSSQL server to pull in some additional fields that aren't available in riteScan. I know it’s possible to join across different database connection types, but every time I set up the connection, I get an error stating that too many records are returned in the recordset. However, I’m certain that the stockcode should return only one row from the joined table.
Simply put, I am trying to implement an inner join between 2 tables. Table_A and Table_B
inner join table_A.col1 = table_B.col1
and table_A.col2 = table_B.col2
The option I get in bartender when I click on + (add condition) is
inner join table_A.col1 = table_B.col1
inner join table_A.col2 = table_B.col2
Which results in the error attached
Can the community provide any guidance on this?
Thank you!
-
I think you just need one join condition, so just try it with the top one.
On you label template you can decide whether you want to use the matching data in table_A.col2 or table_B.col2 as they are the same.
0 -
Just an update, I created a composite key value in my text file source as a workaround. If the community has a better solution please share
0
Please sign in to leave a comment.
Comments
2 comments