How to multi-join with SQL and TXT file? Getting error. 关注
I have a system that kicks out a text file for print jobs, which Commander picks up. I also have a SQL database with some supplemental data which needs to be combined into my labels. I can join one field from the text file to one in the database and populate a separate database field (GTIN) onto the label. The thing is, I need to join two fields from the text file to two separate fields in the database, and the system is throwing this error message.
Any ideas? I could work around this from SQL's end by creating a view that combines the two fields into one, but unless I can do something like that with the text file, I see no way to join two fields from the text file as needed. VB Scripting allows fields to be combined, but that is not a selectable item in the drop down where the joins are being specified.
Ignoring the error does no good; it throws again when I try and print.