ssrs连接Oracle数据库的参数问题
0
select b.name as "店仓名称",c.name as "商品",d.value1 as "颜色",d.value2 as "尺寸",sum(a.qty)
from fa_storage a
left join c_store b on a.c_store_id=b.id
left join m_product c on a.m_product_id=c.id
left join m_attributesetinstance d on a.m_attributesetinstance_id=d.id
where b.c_storekind_id=52
and (b.name in (@storename))
group by b.name,c.name,d.value1,d.value2
这是连接Oracle数据库的sql语句,加上and (b.name in (@storename))后报错,说是缺少表达式,请问是什么问题呢
from fa_storage a
left join c_store b on a.c_store_id=b.id
left join m_product c on a.m_product_id=c.id
left join m_attributesetinstance d on a.m_attributesetinstance_id=d.id
where b.c_storekind_id=52
and (b.name in (@storename))
group by b.name,c.name,d.value1,d.value2
这是连接Oracle数据库的sql语句,加上and (b.name in (@storename))后报错,说是缺少表达式,请问是什么问题呢
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-10-22 回答
赞同来自: