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

  • November 9, 2011 at 11:19 am

    #1405399

    Ninja's_RGR'us (11/9/2011)

    Well you could do it like this if you wanted to =>

    FROM SchoolProgram srp

    INNER JOIN @Programs pr ON srp.ProgramID = 7

    Thanks, so above statement, for inner join it doesn't need to join on a matched column?

    I just feel it's kind of hard for me to understand this cross join.