Sele tempyf. *,;
The sum (iif (isnull (recdbf. Date) or the at (" general ", recdbf. Nature)=0, 1)) as general,;
The sum (iif (isnull (recdbf. Date) or the at (" big ", recdbf properties)=0, 1)) as large,;
The sum (iif (isnull (recdbf. Date) or the at (" major ", recdbf. Nature)=0, 1)) as a major,;
The from e: \ syb \ tempyf DBF left outer join e: \ syb \ recdbf DBF.
On tempyf. Yf=month (recdbf. Date) and recdbf. Year (date)=2000;
Group by tempyf yf

CodePudding user response:

Statement itself may be right, try to statements into multiple string literals are concatenated with a plus sign, or in the text to... Block to implement
The Text to cSql Noshow
Sele tempyf. *,;
The sum (iif (isnull (recdbf. Date) or the at (" general ", recdbf. Nature)=0, 1)) as general,;
The sum (iif (isnull (recdbf. Date) or the at (" big ", recdbf properties)=0, 1)) as large,;
The sum (iif (isnull (recdbf. Date) or the at (" major ", recdbf. Nature)=0, 1)) as a major,;
The from e: \ syb \ tempyf DBF left outer join e: \ syb \ recdbf DBF.
On tempyf. Yf=month (recdbf. Date) and recdbf. Year (date)=2000;
Group by tempyf. Yf
EndText
& CSQl

CodePudding user response:

Statement itself may be right, try the statement into multiple string literals are concatenated with a plus sign.
Please guide!
The contents of the two tables as follows,


There is a problem:
At (" general ", recdbf. Nature)
Ats function is the location of the query parameter in the parameter 2, but why there are "serious" in the "nature", the return value is zero?