1 of 1 people found this helpful
The answer depends if the IDs points to the same or different vendor. If point to different ref_vendors lines, you need to add the [Ref_Vendors] table twice, like
Ref_Vendors RIGHT JOIN T
Ref_Vendors_1 RIGHT JOIN T
If you have a situation where only one ref_vendor ID can be found but only in one of the columns you can use custom SQL with OR in join conditions
Thanks, Tamas! Ultimately we ended up adding the [ref_vendors] a second time, pointed the second vendor ID at it and that resolved it pretty quickly. It was interesting because I had no idea T would automatically duplicate a table if you added it a second time...