将Access语法转换为SQL语法

Question

我正试图将以下内容转换为使用Case-When-Then等从Access数据库语法到sql查询语法。有人能帮帮我吗?

SpreadType: IIf ([mv_Loan_Ext1] ![LoanPurposeTypeCode] In ("008"，"080")，"QRLF-",IIf ([FAReceivesPatronage] = 0,"NPAT","PAT")、国际金融([SecDistrictIndustryCode] ="999","Non-QRLF", IIf ([PriDistrictIndustryCode] ="999","RHL", IIf ([mv_Loan_Ext1] ![LoanPurposeTypeCode]+0 1到7之间，"其他家庭"，IIf([fanoteisparticipationpurchase1]=1,IIf([mv_FANote]![BranchNbr]="092"，"100% GP"，"PP")，IIf([PatronagePoolCode]="14"，"FCE"，IIf([YBSAgStart] " "No"或者IIf(Trim([AgGrow_NoOperator])是Null,0,IIf(Trim([AgGrow_NoOperator])="Or Trim([AgGrow_NoOperator])="No"，0,1))+IIf(Trim([AgNiche])是Null,0,IIf(Trim([AgNiche])="Or Trim([AgNiche])="No"，0,1))+IIf(Trim([AgGrowOperator])是Null,0,IIf(Trim([AgGrowOperator])="或Trim([AgGrowOperator])="No"，0,1)) " 0，"YBS AgStart"，IIf([GrainInventoryLoan]="Yes"，"Grain Inventory"，IIf([covid - 19] Like "SBA*"，" pp"，IIf([FCALoanTypeAbbr]="PRIT"，"FL")， IIf([FCALoanTypeAbbr]="REMG"，"FL")，[FarmTypeAbbr]) " FL"，"一般非农"，"核心农民贷款"))))))))))

Answer 1

您必须像这样重写查询。你只是有太多的embed()。这有点乱。

select 
case when [mv_Loan_Ext1].[LoanPurposeTypeCode] in ('008', '080') then 'QRLF-' + case FAReceivesPatronage when 0 then 'NPAT' else 'PAT' end
when [SecDistrictIndustryCode] = '999' THEN 'Non-QRLF'
when ...
end