icase问题 - 意外结果 [英] icase issues - unexpected results

问题描述

所以我是我公司的软件技术支持代表，我在需要时进行数据分析和数据清理。我在使用SQL / FOX
程序时遇到了一些问题。使用FoxPro 9. 

So I am a software technical support rep for my company, and I do data analysis and data cleanup when needed. I am having some issues with a SQL/FOX program. Using FoxPro 9. 

CODE - > FoxPro / SQL

UPDATE table1;
SET datefield1 =;
ICASE(;
        t1.datefield2 < CTOD("04/23/2018") AND t1.datefield2 > CTOD("01/01/1900") AND t2.datefield1 = ctod("") and t2.datefield2 = ctod("") and t2.datefield3 = ctod("") and t3.datefield1 = CTOD(""), t3.datefield2,;
        t1.datefield2 < CTOD("04/23/2018") AND t1.datefield2 > CTOD("01/01/1900") AND t2.datefield1 = ctod("") and t2.datefield2 = ctod("") and t2.datefield3 = ctod(""), t3.datefield1,;
        t1.datefield2 < CTOD("04/23/2018") AND t1.datefield2 > CTOD("01/01/1900") AND t2.datefield3 = ctod("") AND t2.datefield1 = ctod(""), t2.datefield2,;
        t1.datefield2 < CTOD("04/23/2018") AND t1.datefield2 > CTOD("01/01/1900") AND t2.datefield3 = ctod("") AND t2.datefield2 = ctod(""), t2.datefield1,;
	t1.datefield2 < CTOD("04/23/2018") AND t1.datefield2 > CTOD("01/01/1900") AND t2.datefield3 <> ctod(""), t2.datefield3,;
    t1.datefield1;
       );
from table1 t1;
join table2 t2 on t1.key=t2.key;
join table3 t3 on t3.key=t2.key;
where t1.datefield2 BETWEEN CTOD("01/01/1900") and CTOD("04/23/2018") and t1.datefield1 = ctod("") 

推荐答案

尝试以下

from table1 t1;
join table2 t2 on t1.key=t2.key;
join table3 t3 on t1.key=t3.key;

这篇关于icase问题 - 意外结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！