I am trying to write a query that will access the same table column for lookups twice. In this case there are two columns that reference a serverid column in another table. How can I return the hostname for each column? All of the ways I have tried it end up with the same column in the select list twice.