如果条件在Sql查询下面我怎么写 [英] How I Can Write If Condition In Below Sql Query

问题描述

 选择 farmer_code，bank_name 来自 farmer_master，bank_master 
 其中 farmer_master.bank_code = bank_master.bank_code 和 
  if （{bank_master.ISFC_CODE}） LIKE （  * ALLA *） AND 长度（{farmer_master.BANK_ACNO}）= 11 然后  正确 其他 
  IF （{bank_master.ISFC_CODE}）=（  KSCB） AND 长度（{farmer_master.BANK_ACNO}）= 12 然后   CORRECT  else   错误 

解决方案

首先，使用连接，不要这样做多个表。它是如此古老的风格，我甚至不记得它叫什么。



做这样的事情：

< pre lang =SQL> SELECT farmer_code，bank_name，
CASE b.ISFC_Code LIKE ' ％ALLA％' AND LEN（f.bank_acno）= 11 那么 ' 更正'
ELSE - ...我会让你完成它
结束 AS SomeNewField
FROM farmer_master f
LEFT JOIN bank_ master b ON f.bank_code = b.bank_code

select farmer_code,bank_name from farmer_master,bank_master
 where farmer_master.bank_code=bank_master.bank_code and
 if ({bank_master.ISFC_CODE}) LIKE ("*ALLA*") AND Length ({farmer_master.BANK_ACNO})=11 then "CORRECT" else
 IF ({bank_master.ISFC_CODE})=("KSCB") AND Length ({farmer_master.BANK_ACNO})=12 then "CORRECT" else "WRONG"

解决方案

First off, use a join, don't do multiple tables this way. It's such an old style of doing it that I don't even remember what it is called.

Do something like this:

SELECT farmer_code, bank_name, 
    CASE b.ISFC_Code LIKE '%ALLA%' AND LEN(f.bank_acno) = 11 THEN 'Correct'
       ELSE -- ... I'll let you finish it
    END AS SomeNewField
FROM farmer_master f
LEFT JOIN bank_master b ON f.bank_code = b.bank_code

这篇关于如果条件在Sql查询下面我怎么写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！