上下文绑定语法[重复](Context binding syntax [duplicate])

 
 
 
 ...当子串（B.gl_accountcode，9,2）='60'作为条件1时，以及当（B.gl_accountcode）='40000000003102'和子串（B.gl_accountcode，9,2）='60'时与条件2相同的GL参考。 
 
 
 当子串（B.gl_accountcode，9,2）不是'60'并且（B.gl_accountcode）='40000000003102'时，我不想在MOE列中填充'60' 
 
 
 更容易说是...... 
 
60 when 

substring(x) = '60'
OR
(B.gl_accountcode = 'y' and substring(x) = '60')

(...and not when (B.gl_accountcode = 'y' and substring(x) <> '60')
 
 这基本上是 
 
substring(x) = '60'
 
 所以你的最后陈述是： 
 
select 
RTRIM(LTRIM(B.gl_accountcode)) as 'GL AccountCode',
RTRIM(LTRIM(B.gl_reference)) as 'GL Reference',
RTRIM(LTRIM(B.gl_subledger_code)) as 'GL Subledger Code',
CASE 
WHEN substring(B.gl_accountcode,9,2) = '60' 
THEN '60'
ELSE ''
END MOE 
from pronto_NZD_GLTransUnion B
where B.gl_reference in ( '00025928', '00001064')
order by B.gl_reference, B.gl_accountcode
 
 
 编辑：当我在等待你想要的结果时，这可能是你想要的吗？ 
 
select 
RTRIM(LTRIM(B.gl_accountcode)) as 'GL AccountCode',
RTRIM(LTRIM(B.gl_reference)) as 'GL Reference',
RTRIM(LTRIM(B.gl_subledger_code)) as 'GL Subledger Code',
CASE 
WHEN substring(B.gl_accountcode,9,2) = '60' THEN '60'
WHEN gl_accountcode = '40000000003102' AND EXISTS (SELECT 1 FROM pronto_NZD_GLTransUnion a WHERE substring(a.gl_accountcode,9,2) = '60' AND a.gl_reference = B.gl_reference) THEN '60'
ELSE ''
END MOE 
from pronto_NZD_GLTransUnion B
where B.gl_reference in ( '00025928', '00001064')
order by B.gl_reference, B.gl_accountcode
 
 
 
 看到它在sqlfiddle中工作 
 

 
 
 
 
  
... 60 when substring(B.gl_accountcode,9,2) = '60' as condition 1 and also when (B.gl_accountcode) = '40000000003102' and substring(B.gl_accountcode,9,2) = '60' for same GL Reference as condition 2.
 
  
I don't want to populate '60' in MOE column when substring(B.gl_accountcode,9,2) is not '60' and (B.gl_accountcode) = '40000000003102'
 
 
 
Easier said is...
 
60 when 

substring(x) = '60'
OR
(B.gl_accountcode = 'y' and substring(x) = '60')

(...and not when (B.gl_accountcode = 'y' and substring(x) <> '60')
 
Which basically is
 
substring(x) = '60'
 
So your final statement is:
 
select 
RTRIM(LTRIM(B.gl_accountcode)) as 'GL AccountCode',
RTRIM(LTRIM(B.gl_reference)) as 'GL Reference',
RTRIM(LTRIM(B.gl_subledger_code)) as 'GL Subledger Code',
CASE 
WHEN substring(B.gl_accountcode,9,2) = '60' 
THEN '60'
ELSE ''
END MOE 
from pronto_NZD_GLTransUnion B
where B.gl_reference in ( '00025928', '00001064')
order by B.gl_reference, B.gl_accountcode
  
 
EDIT: While I'm waiting for your desired result, could this be what you're looking for?
 
select 
RTRIM(LTRIM(B.gl_accountcode)) as 'GL AccountCode',
RTRIM(LTRIM(B.gl_reference)) as 'GL Reference',
RTRIM(LTRIM(B.gl_subledger_code)) as 'GL Subledger Code',
CASE 
WHEN substring(B.gl_accountcode,9,2) = '60' THEN '60'
WHEN gl_accountcode = '40000000003102' AND EXISTS (SELECT 1 FROM pronto_NZD_GLTransUnion a WHERE substring(a.gl_accountcode,9,2) = '60' AND a.gl_reference = B.gl_reference) THEN '60'
ELSE ''
END MOE 
from pronto_NZD_GLTransUnion B
where B.gl_reference in ( '00025928', '00001064')
order by B.gl_reference, B.gl_accountcode
 
 
 
see it working live in an sqlfiddle