DROP TABLE itservices
SELECT dbo.StudentDetail.RefNo, dbo.StudentDetail.Surname AS StudentSurname, dbo.StudentDetail.FirstForename AS StudentFirstnames, dbo.StudentDetail.DateOfBirth AS DoB, dbo.CollegeLevel.Code + dbo.Offering.Code + ' ' + dbo.Offering.Name AS Course, dbo.Offering.AnnualGLH, dbo.Site.Description AS Site, dbo.Enrolment.CreatedDate INTO dbo.ITServices
FROM dbo.StudentDetail 
	INNER JOIN ((dbo.Site 
		INNER JOIN ((dbo.Enrolment 
			INNER JOIN dbo.Offering ON dbo.Enrolment.OfferingID = dbo.Offering.OfferingID) 
				INNER JOIN dbo.CollegeLevel CollegeLevel_1 ON dbo.Offering.SID = CollegeLevel_1.SID) 
			ON dbo.Site.SiteID = dbo.Offering.SiteID) 
			INNER JOIN dbo.CollegeLevel ON (CollegeLevel_1.ParentLevelNum = dbo.CollegeLevel.LevelNum) AND (CollegeLevel_1.ParentSID = dbo.CollegeLevel.SID)) 
		ON dbo.StudentDetail.StudentDetailID = dbo.Enrolment.StudentDetailID
WHERE (((dbo.StudentDetail.AcademicYearID)='07/08') 
AND ((dbo.Offering.AcademicYearID)='07/08') 
AND ((dbo.Enrolment.CompletionStatusID)='1') 
AND ((dbo.Enrolment.IsWBL)=0) 
AND ((dbo.Offering.OfferingStatusID)='1') 
AND ((CollegeLevel_1.LevelNum)='2') 
AND ((dbo.CollegeLevel.LevelNum)='1'))
AND (dbo.site.description !='*****')
AND (dbo.site.description ='*****')
AND (dbo.site.description !='*****')
AND (dbo.site.description !='*****')
AND (dbo.site.description !='*****')
AND (dbo.site.description !='*****')
AND (dbo.site.description !='*****')
AND (dbo.site.description !='*****')
AND (dbo.site.description !='*****')
AND (dbo.site.description !='*****')
ORDER BY dbo.StudentDetail.RefNo, dbo.StudentDetail.Surname, dbo.StudentDetail.FirstForename, dbo.Offering.AnnualGLH DESC;
select distinct refno, studentSurname, studentFirstnames, dob, site from dbo.itservices