in reply to Class::DBI and sql order by
SELECT * from customer,region WHERE customer.region=region.id ORDER BY region.name [download]