查询sale_detail表的region为杭州地区和上海地区的所有记录，并将它们合并起来。下列语句可以实现的是？

A. Select * from sale detail where region= hangzhou'unionSelect * from sale detailwhere region = shanghai;
B. Select * from sale detail where region= 'hangzhou'union allSelect * from sale detail where region = shanghai;
C. Select * from sale_ detail where region='hangzhou' and region='shanghai";
D. Select * from sale detail where region in('hangzhou', 'shanghai');