insert into membermaster (dimcode,lvlcode,membercode,membername,memberdesc)
select 'Store' DIMCODE, 'Area' lvlcode, e membercode, e membername, e memberdesc from
(select distinct(mbr_area) e from v_dim_store);