It appears that SQL field reference automatically ...
# administration
d
It appears that SQL field reference automatically targets the preferred vendor, but there are cases where we want to ignore the preferred and pull the second, non preferred vendor on the results