Why can't I use a table alias in a subquery?

0 votes

1 answer

1890 views

                          I have a MS Access database. When I try to run this query:

    SELECT *
    FROM 
    (
      SELECT * 
      FROM tblClients AS a1 
      LEFT JOIN 
      (
        SELECT TOP 1 lVersion, lRequestID AS lVerReqId, lClientId    
        FROM tblClientsVersionsHistory 
        WHERE ID = (
          SELECT MAX(ID) 
          FROM tblClientsVersionsHistory 
          WHERE lClientId = a1.Id
        )
      ) AS a2
      ON a1.Id = a2.lClientId
    )

It suggest me to enter a1.Id, but I want to use it from (SELECT * FROM tblClients AS a1).


                        

Asked by John (11 rep)

Dec 14, 2020, 10:27 AM
Last activity: Jan 2, 2023, 05:01 PM

Why can't I use a table alias in a subquery?

Related Questions