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