Hi i would like to ask for your assistance why i’m getting error. “The specified field ‘t0.UserID’ could refer to more than one table in the FROM clause of your SQL statement.”

Code:

SELECT
    t2.KPICode1 AS OrigCode,
    t0.KPITask AS OrigTask,
    t2.ID AS TimID,
    t2.Score AS OrigScore,
    t3.ID AS AccID,
    t3.Score AS DepScore,
    t1.KPICode AS DepCode,
    t1.KPITask AS DepTask,
    IIF(ISNULL(t4.RevCount), 0, t4.RevCount) AS RevCount
FROM
    (((KPI_qryMain AS t0
    LEFT JOIN KPI_qryMain AS t1 ON t1.KPICode = t0.ChildKPICode)
    LEFT JOIN KPI AS t2 ON t2.KPICode = t0.KPICode)
    LEFT JOIN KPI AS t3 ON t3.KPICode = t0.ChildKPICode AND t3.UserID = t0.UserID)
    LEFT JOIN
    (SELECT COUNT(*) AS RevCount, RefNum
     FROM KPI_tblLogs
     WHERE Title = 'Daily Task'
     AND LogDetails LIKE '%For revision%'
     GROUP BY RefNum) AS t4 ON t4.RefNum = CSTR(t2.ID)
WHERE
    t2.DueDate = #8/12/2024 6:00:00 PM#
    AND t3.DueDate = #8/12/2024 6:00:00 PM#
    AND t0.KPICode = 'SRSMRT03'
    AND t2.UserID = 'XXX000165'