阅读背景:

左连接OR运算符优先级

来源:互联网 

I have the following query:

我有以下查询:

SELECT * FROM 
dbo.Driver d
    LEFT JOIN #Test t ON  
       ((d.LicenseNumber = REPLACE(REPLACE(t.[LicNumber],'-',''),' ','')) 
        OR 
       (d.[BirthDate] = t.[BirthDate]
        AND  d.[LastName] = t.[LastName]
        AND d.[FirstName] = t.[FirstName])
        OR
       (SUBSTRING(d.[LicenseNumber], PATINDEX('%[^0]%', d.[LicenseNumber] + '.'), LEN(d.[LicenseNumber]))) = t.[LicNoZero])
SELECT 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: