M
mscertified
SELECT Q.*, D.TargetDate AS GRRCHTarg, D.ActualDate AS GRRCHAct
FROM (qryRpt5YrProgress4 AS Q LEFT JOIN tblPkgDates AS D ON
Q.[5YrPkgID]=D.PkgID) LEFT JOIN tblPkgDateTypes AS DT ON D.DateTypeID = DT.ID
WHERE DT.DateType = 'GRRC Hearing';
qryRpt5YrProgress4 returns 1907 rows, yet the above query returns only 1645
rows. I thought a left join was supposed to return all the rows in the
leftmost table? I need to get all the rows in qryRpt5YrProgress4 with the
results of the other joins in the 2 new columns.
FROM (qryRpt5YrProgress4 AS Q LEFT JOIN tblPkgDates AS D ON
Q.[5YrPkgID]=D.PkgID) LEFT JOIN tblPkgDateTypes AS DT ON D.DateTypeID = DT.ID
WHERE DT.DateType = 'GRRC Hearing';
qryRpt5YrProgress4 returns 1907 rows, yet the above query returns only 1645
rows. I thought a left join was supposed to return all the rows in the
leftmost table? I need to get all the rows in qryRpt5YrProgress4 with the
results of the other joins in the 2 new columns.