• Can't see a difference between queries 2 and 3. I can't tell which will run faster, you'll have to do that. Turn Statistics Time on and run them.

    p.s. Why the meaningless aliases? They don't help readability, rather the opposite. If you're going to alias the tables, use something indicative of the table, eg from SY_DMS_AUTHORIZATION AS sda left outer join HR_JOBS AS hj

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass