Home Forums SQL Server 2008 T-SQL (SS2K8) join on 1=1 RE: join on 1=1

  • November 9, 2011 at 11:14 am

    #1405397

    sqlfriends (11/9/2011)

    so if I change the join to cross join and take off 1=1, it will be the same, correct?

    Yes

    But I read somewhere if a cross join have a where clause, it is the same as inner join,

    Depends what the where clause is.

    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