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