我创建的SQL查询如下:SELECT DISTINCT Chemical.Chemical_Name, Hazard.Hazard_Code, Hazard.Hazard_Text WHERE Chemical.Chemical_Id = Chemical_Hazard.Chemical_Idand Chemical
[FIRST_PRIN_BAL],HAZARD.[352_Ins_Co_Code] from HAZARD where (((HAZARD.[352_Ins_Co_Code]) = [PAYEE_CODE[LOAN_NO],HAZARD.[FIRST_PRIN_BAL],HAZARD.["352_Ins_Co_Code] from HAZARD where (((HAZARD.[352_Ins_Co_Code"]) = [PAYEE_CODE[LOA