MSAccess错误:当尝试连接两个以上的表时，所需参数没有给定值

Question

我对MS Access的查询如下：

SELECT po.[PONumber] AS [Purchase Invoice Number]
    , po.[PODate] AS [Purchase Date]
    ,po.PODeposit AS [Purchse Deposit]
    , po.PORemarks AS [Remarks]
    , pitem.PQuantity AS [Quantity]
    , pitem.PPricePerUnit AS [Price Per Unit]
    , pitem.PAmount AS [Amount Paid]
    ,  pclient.PClientName AS [Client]
    , pclient.PClientName.PTel AS [Telephone]
    , pclient.PAddress AS [Address]  
FROM ((PurchaseOrderInvoice AS  po
INNER JOIN PItemDetails AS pitem  ON po.POInvoiceId = pitem.fk_POId)
INNER JOIN PClients AS pclient ON pitem.fk_PClientId = pclient.PClientId) 

它引发一个错误，如“一个或多个所需参数没有给定值”。我哪里出问题了？

Answer 1

我得到了答案，实际上电话里有个错误，我误以为是"pclient.PClientName.PTel“，因为它应该是"pclient.PTel”。