...
View file | ||||
---|---|---|---|---|
|
Possible SQL statement from MS ACCESS :
Code Block | ||
---|---|---|
| ||
SELECT TBLSample.Station_ID, TBLSample.Sample_CodeTBLStation_Information.Latitude, TBLStation_Information.Longitude, TBLSample.IDLocStart_Date, TBLResults.IDLocResult_Value, TBLParameter_Group.Parameter_Group, TBLParameter_Codes.Full_Name, TBLParameter_Codes.Short_Name, FROM TBLStation_Information RIGHT JOIN (((((TBLResults INNER JOIN TBLSample ON (TBLResults.Sample_Code = TBLSample.Start_Date, TBLResults.Result_Value, TBLParameter_Group.Parameter_Group FROM TBLParameter_GroupSample_Code) AND (TBLResults.IDLoc = TBLSample.IDLoc)) INNER JOIN TBLParameter_Codes ON TBLResults.Parameter_Code = TBLParameter_Codes.Parameter_Code) INNER JOIN (TBLQAPP_Group_Codes INNER JOIN (TBLQAPPGroups TBLQAPPGroups ON TBLParameter_Codes.Parameter_Code = TBLQAPPGroups.Parameter_Code) INNER JOIN (TBLParameterTBLQAPP_Group_Codes ON INNERTBLQAPPGroups.QAPPCode JOIN (TBLSample= TBLQAPP_Group_Codes.QAPPCode) INNER JOIN TBLResultsTBLParameter_Group ON TBLSample.Sample_CodeTBLQAPP_Group_Codes.Parameter_Group = TBLResultsTBLParameter_Group.SampleParameter_CodeGroup) ON TBLStation_Information.Station_ID = TBLSample.Station_ID WHERE (((TBLParameter_CodesGroup.Parameter_Code = TBLResults.Parameter_Code) ON TBLQAPPGroups.Parameter_Code = Group)=9 Or (TBLParameter_Group.Parameter_Group)=10)); |
SELECT TBLSample.Station_ID, TBLStation_Information.Latitude, TBLStation_Information.Longitude, TBLSample.Start_Date, TBLResults.Result_Value, TBLParameter_Group.Parameter_Group, TBLParameter_Codes.Full_Name, TBLParameter_Codes.Short_Name
FROM TBLStation_Information RIGHT JOIN (((((TBLResults INNER JOIN TBLSample ON (TBLResults.Sample_Code = TBLSample.Sample_Code) AND (TBLResults.IDLoc = TBLSample.IDLoc)) INNER JOIN TBLParameter_Codes ON TBLResults.Parameter_Code = TBLParameter_Codes.Parameter_Code)
...
INNER JOIN TBLQAPPGroups ON TBLParameter_Codes.Parameter_Code = TBLQAPPGroups.Parameter_Code) INNER JOIN TBLQAPP_Group_Codes ON TBLQAPPGroups.QAPPCode
...
= TBLQAPP_Group_Codes.QAPPCode)
...
INNER JOIN TBLParameter_Group ON TBLQAPP_Group_Codes.Parameter_Group
...
=
...
TBLParameter_Group
...
.Parameter_Group
...
) ON TBLStation_Information.Station_ID = TBLSample.Station_ID
WHERE (((TBLParameter_Group.Parameter_Group)=9
...
Or
...
(TBLParameter_Group.Parameter_Group)=10));
...