python - 将 SQL 联接转换为 Python

Question

SELECT *
FROM PlacementDetail_Temp PDT LEFT JOIN    
     dbo.[Authorization] AUTH
     on AUTH.PlacementDetailID = PDT.PlacementDetailID and
        AUTH.PayorID = @PayorID LEFT JOIN
     dbo.Provider SP_as_PR
     on SP_as_PR.ProviderID in
            (Select PR.ProviderID     
             from dbo.Provider PR JOIN
                  dbo.ProviderSponsor PS
                  ON PR.ProviderID = PS.ProviderID and
                     PS.SponsorID = AUTH.SponsorID    
             where IsSponsor = 'True'
            )

我们一直在尝试将此 sql join 转换为 python。但我们没能做到。卡在这个'LEFT JOIN dbo.Provider SP_as_PR on SP_as_PR.ProviderID in'点

因为他们使用“in”条件而不是“on”条件加入

标签： pythonsqlsql-serverjoin