I'm trying to join two table between master and child table. I want to show all aircraft registration for specified aircraft type even if there is no flight record at the time specified.
Code:
SELECT TYPE, SREG, Sum(FLT_MINUTES)/60/7 AS [AVG FH], Sum(FLT_MINUTES) AS FM, Count(FLT_MINUTES) AS CYCLE FROM AC RIGHT JOIN WEEKLY ON AC.SREG = WEEKLY.AC_REG WHERE DEP_UTC BETWEEN