Need the ability to create multiple relationships between table pairs. Example: Dynamics GP - SOP Sales Transactions and Sales Line Items have to be joined by SOP Type AND by SOP Number.
This is a major point of frustration for me. Too often I would need to join on 3 or four columns, adding new columns as a workaround is just frustrating and unnecessary. Also, I don't want them in the same table, so merging the tables in the query editor is useless.
