SQL - запрос на "выборку из результатов запроса"

SELECT
 [Display FULL Rate Names AND NUMERIC Rate].ActiveParticipantID AS ActiveParticipantID,
 [Display FULL Rate Names AND NUMERIC Rate].Title AS Title,
 [Display FULL Rate Names AND NUMERIC Rate].LastName AS LastName, 
[Display FULL Rate Names AND NUMERIC Rate].FirstName AS FirstName,
 [Display FULL Rate Names AND NUMERIC Rate].TypeOfRate AS TypeOfRate,
 [Display FULL Rate Names AND NUMERIC Rate].FamilyPaymentRate AS Rate,
 [Display FULL Rate Names AND NUMERIC Rate].ParticipantOrderID AS ParticipantOrderID
 
FROM [Display FULL Rate Names AND NUMERIC Rate]
 
GROUP BY 
[Display FULL Rate Names AND NUMERIC Rate].ActiveParticipantID,
 [Display FULL Rate Names AND NUMERIC Rate].Title,
 [Display FULL Rate Names AND NUMERIC Rate].LastName,
 [Display FULL Rate Names AND NUMERIC Rate].FirstName,
 [Display FULL Rate Names AND NUMERIC Rate].TypeOfRate,
 [Display FULL Rate Names AND NUMERIC Rate].FamilyPaymentRate, 
[Display FULL Rate Names AND NUMERIC Rate].ParticipantOrderID
 
UNION SELECT 
[Active Participant TABLE].ActiveParticipantID AS ActiveParticipantID,
 [Active Participant TABLE].Title AS Title,
 [Active Participant TABLE].LastName AS LastName,
 [Active Participant TABLE].FirstName AS FirstName, 
 
[Active Participant TABLE].TypeOfRate AS TypeOfRate,
 [Equation Half Rate].SinglePaymentRate AS Rate,
 [Active Participant TABLE].ParticipantOrderID AS ParticipantOrderID
 
FROM [Active Participant TABLE], [Equation Half Rate]
GROUP BY [Active Participant TABLE].ActiveParticipantID, [Active Participant TABLE].Title, [Active Participant TABLE].LastName, [Active Participant TABLE].FirstName, [Active Participant TABLE].MiddleInitial, [Active Participant TABLE].TypeOfRate, [Equation Half Rate].SinglePaymentRate, [Active Participant TABLE].ParticipantOrderID
HAVING ((([Active Participant TABLE].TypeOfRate)='single'));

SELECT NEW.ActiveParticipantID, NEW.Title, NEW.LastName, NEW.FirstName, NEW.TypeOfRate, FIRST(NEW.Rate) AS [First-Rate], NEW.ParticipantOrderID
FROM NEW
GROUP BY NEW.ActiveParticipantID, NEW.Title, NEW.LastName, NEW.FirstName, NEW.TypeOfRate, NEW.ParticipantOrderID;