I'm reviewing some old code, and came accross something I implemented a while back and can't remember what it does.
Normally when I join tables, it looks like:
LEFT OUTER JOIN Contacts C ON C.ContactNo = I.BillContactNo (as an example)
Here's what I came accross, and need help understanding what it does:
LEFT OUTER JOIN Contacts C ON C.ContactNo IN (I.BillContactNo, J.OrdContactNo)