select distinct indent_name,calltel_mask,indent_level1+indent_address,memo,'',
money_total,convert(varchar(10),indent_date,120),goods_detail,
case when goods_detail like'%礼品 Z%' then'NXB01' when goods_detail like'%礼品 L%' then'NXA01'when goods_detail like'%礼品 Y%' then'NXA01'when goods_detail like'%礼品 MK%' then'NXA01' end,c.emp_group
from t_indent a
join t_doindent b on a.indent_id = b.indent_id
join t_employee_inf c on a.ask_id=c.emp_id
Where datediff(year,[indent_date],getdate())=0
消息 209,级别 16,状态 1,第 3 行
列名 'memo' 不明确。
需要查寻表名t_indent里面的memo字段,新人入门求教大神指点。
------解决思路----------------------
如果上面的解释还不清楚,直接试一下下面的sql.
select distinct indent_name,calltel_mask,indent_level1+indent_address,a.memo,'',
money_total,convert(varchar(10),indent_date,120),goods_detail,
case when goods_detail like'%礼品 Z%' then'NXB01' when goods_detail like'%礼品 L%' then'NXA01'when goods_detail like'%礼品 Y%' then'NXA01'when goods_detail like'%礼品 MK%' then'NXA01' end,c.emp_group
from t_indent a
join t_doindent b on a.indent_id = b.indent_id
join t_employee_inf c on a.ask_id=c.emp_id
Where datediff(year,[indent_date],getdate())=0