Hm, that would be more elegant, except that we need to join on host.name.  Not sure if that is possible with join.