...
View file |
---|
name | NMC-Fox-River-Data.pptx |
---|
height | 250 |
---|
|
SQL statement from MS ACCESS:
Code Block |
---|
|
SELECT TBLSample.Station_ID, TBLSample.Sample_Code, TBLSample.IDLoc, TBLResults.IDLoc, TBLParameter_Codes.Full_Name, TBLParameter_Codes.Short_Name, TBLSample.Start_Date, TBLResults.Result_Value, TBLParameter_Group.Parameter_Group INTO temp
FROM TBLParameter_Group INNER JOIN (TBLQAPP_Group_Codes INNER JOIN (TBLQAPPGroups INNER JOIN (TBLParameter_Codes INNER JOIN (TBLSample INNER JOIN TBLResults ON TBLSample.Sample_Code = TBLResults.Sample_Code) ON TBLParameter_Codes.Parameter_Code = TBLResults.Parameter_Code) ON TBLQAPPGroups.Parameter_Code = TBLParameter_Codes.Parameter_Code) ON TBLQAPP_Group_Codes.QAPPCode = TBLQAPPGroups.QAPPCode) ON TBLParameter_Group.Parameter_Group = TBLQAPP_Group_Codes.Parameter_Group
WHERE (((TBLParameter_Group.Parameter_Group)=9 Or (TBLParameter_Group.Parameter_Group)=10));
|