I'm reviewing the sql code of others, I know what it does, but not sure how to understand about the join on 1=1 means?
The sql is basically to insert some rows into based on some existing rows in the same table, but just change the programID.
DECLARE @Programs TABLE
INSERT INTO @Programs SELECT 30
INSERT INTO @Programs SELECT 31
INSERT INTO @Programs SELECT 32
INSERT INTO SchoolProgram
FROM SchoolProgram srp
JOIN @Programs pr ON 1 = 1
WHERE srp.ProgramID = 7