>I have 3 tables - Campuses, Departments, and CampusDepartments
>
>After I do the inserts for the campuses and departments, how can I do a SELECT INTO so that each department will be linked to each campus in the CampusDepartments?
>
>Thanks

select campuses.campusId, Departments.DepartmentID
into CampusDepartments
from Campuses
cross join Departments

Cetin