select vend_id, vend_name vname,vend_address vaddress,vend_city vcity
from Vendors
order by vend_name;

as 全省略了，asc也省了