取数查询条件

Question

我需要Microsoft Access查询条件的语法来说明

If TblA.ColA = TblB.ColA And
   TblA.ColB = TblB.ColB And
   TblB.ColC = QueryFieldA And
   TblB.ColD = QueryFieldB
Then 
    give me the number in TblB.Col E
End If

有什么建议吗？

Answer 1

我假设这两个表必须在ColA和ColB上连接(在不了解表结构的情况下很难说)。

SELECT TblB.ColE
FROM
    TblA
    INNER JOIN TblB
        ON TblA.ColA = TblB.ColA AND
           TblA.ColB = TblB.ColB 
WHERE
    TblB.ColC = QueryFieldA AND
    TblB.ColD = QueryFieldB