oracle语句报缺失表达式,貌似是decode用法不对?where t1.high_company_id =decode(c1.company_level,'4',select high_company_id from fnd_company_level where company_id= c1.company_id ,c1.company_id )
问题描述:
oracle语句报缺失表达式,貌似是decode用法不对?
where t1.high_company_id =decode(c1.company_level,'4',select high_company_id from fnd_company_level where company_id= c1.company_id ,c1.company_id )
答
select high_company_id from fnd_company_level where company_id= c1.company_id
给这个SQL加()啊,你不加括号的话,sql之间的空格他怎么识别啊