I have a table with JoinID (key); ProductID (ref); VendorID (ref) and Pref (Number from 1-10). I’d like to return the VendorID’s according with the lowest Pref value first, but only of a certain ProductID. Below works (sorts) but returns the key, I c...