text: ﻿CREATE VIEW dbo.vCancelledRegistrations
  AS
  SELECT        dbo.Students.StudentId, dbo.Students.FirstName, dbo.Students.MI, dbo.Students.LastName, dbo.Students.Email, dbo.RegistrationParticipations.CeremonyId, dbo.RegistrationParticipations.MajorCode, 
                           dbo.RegistrationParticipations.NumberTickets, dbo.RegistrationParticipations.DateRegistered, dbo.RegistrationParticipations.DateUpdated, dbo.Students.Id
  FROM            dbo.Registrations INNER JOIN
                           dbo.RegistrationParticipations ON dbo.Registrations.id = dbo.RegistrationParticipations.RegistrationId INNER JOIN
                           dbo.Students ON dbo.Registrations.Student_Id = dbo.Students.Id
  WHERE        (dbo.RegistrationParticipations.Cancelled = 1)