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

  • November 10, 2011 at 12:29 am

    #1405551

    It's basically doing a cross join. Maybe the author didn't know about that option.

    I haven't seen any instance when people use 1=1 by mistake. It's deliberate CROSS JOIN (just to skip code review tools / team leads 😉 )