SELECT 
    vend_id,
    vend_name AS vname,
    vend_address AS vaddress,
    vend_city AS vcity
FROM
    Vendors
ORDER BY
    vend_name;