SELECT * from customer,region 
   WHERE 
      customer.region=region.id 
   ORDER BY 
      region.name