'use column on joined Table bevor joining

I am trying to acsess a Column on a joined Table bevore joining the Table which is obviosly not working, how can I use dh.void != 1 in the first join?

    FROM TransactionStore.DocHeaderReference    AS dhr

    LEFT OUTER JOIN TransactionStore.DocHeader              AS dh   ON dh.TransactionId = dhr.TransactionId AND dh.DocType = 'SCD1' and info.void != 1
    LEFT OUTER JOIN TransactionStore.DocHeaderInformation   AS info ON info.TransactionId = dh.TransactionId
    
    WHERE dhr.TransactionId = 1
sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions