本文介绍了icase问题 - 意外结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
所以我是我公司的软件技术支持代表,我在需要时进行数据分析和数据清理。我在使用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问题
发布评论