select storeId, storeName, unit,vendor_no as VendorID, payee, contact, telephone, address, bank_name from parkway.store where isActive = 'Y' order by storeName asc #FOR MG select storeId, storeName,category, unit, isActive, is_still_vms_available from store where storeId > 1000 order by storeName asc