select campuses.campusId, Departments.DepartmentID into CampusDepartments from Campuses cross join DepartmentsIf you really meant Insert into, same again with a slight change in syntax:
insert into CampusDepartments (campusID, DepartmentID) select campuses.campusId, Departments.DepartmentID from Campuses cross join DepartmentsCetin