Загрузка данных

INSERT INTO Applications (ApplicantID, SpecialtyID, Status)
SELECT ApplicantID, IDspecialties, Status
FROM Applicants, Specialties
WHERE Name = 'АСОИУ';

INSERT INTO Applications (ApplicantID, SpecialtyID, Status)
SELECT TOP 5 ApplicantID, IDspecialties, Status
FROM Applicants, Specialties
WHERE Name = 'БУАА';

INSERT INTO Applications (ApplicantID, SpecialtyID, Status)
SELECT TOP 6 ApplicantID, IDspecialties, Status
FROM Applicants, Specialties
WHERE Name = 'ЮР';