SELECT
   drives_tbl.LETTER,
   drives_tbl.FOO,
   servers_tbl.NAME
FROM
   servers_tbl
   LEFT OUTER JOIN drives_tbl
     on servers_tbl.ID = drives_tbl.SERVERID
WHERE
   servers_tbl.NAME = "OtherServer"