数据字典查询 ：左连接

	<select id="selectCustomerList" resultType="Customer">
			select 
			cust_id,
			cust_name,
			cust_user_id,
			cust_create_id,
		  b.dict_item_name cust_source,
			c.dict_item_name cust_industry,
			d.dict_item_name cust_level,
		 	cust_linkman,
			cust_phone,
			cust_mobile,
			cust_zipcode,
			cust_address,
			cust_createtime
		from
			customer a
		left join(
			select
				dict_id,
				dict_item_name
			from 
				dict
			where
				dict_type_code='002'
			)b on a.cust_source = b.dict_id	
	
	left join(
			select
				dict_id,
				dict_item_name
			from 
				dict
			where
				dict_type_code='001'
			)c on a.cust_industry = c.dict_id	
left join(
			select
				dict_id,
				dict_item_name
			from 
				dict
			where
				dict_type_code='006'
			)d on a.cust_level = d.dict_id