SELECT mytable.*, column20 AS Customer, column11 FROM mytable -- OR SELECT column11, column20 AS Customer, mytable.* FROM mytable