The view columns can be named independently of the base tables by entering the desired name on the New Column Name line.