icase问题

本文介绍了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;