Select from one table where not in another mssql : hi i have `mssql` `server` db on my computer 
and there is tow `tables`
this is the first one 

        [Participant]SELECT  
           [ParticipantID]
          ,[ParticipantName]
          ,[ParticipantNumber]
          ,[PhoneNumber]
          ,[Mobile]
          ,[Email]
          ,[Address]
          ,[Notes]
          ,[IsDeleted]
          ,[Gender]
          ,[DOB]
      FROM [Gym].[dbo].[Participant]

and this is the second one 

        SELECT  [ParticipationID]
          ,[ParticipationNumber]
          ,[ParticpationTypeID]
          ,[AddedByEmployeeID]
          ,[AddDate]
          ,[ParticipantID]
          ,[TrainerID]
          ,[ParticipationDate]
          ,[EndDate]
          ,[Fees]
          ,[PaidFees]
          ,[RemainingFees]
          ,[IsPeriodParticipation]
          ,[NoOfVisits]
          ,[Notes]
          ,[IsDeleted]
      FROM [Gym].[dbo].[Participation]
now i need to wright mssql query thats can give me 

    select Participant.ParticipantNumber,Participation.ParticipationDate,Participation.EndDate   from  Participation where  Participant.ParticipantID=Participation.ParticipantID 
and im gonna be thankful 
