I have 3 tables: Actions, Advisors, Forecasts. Forecasts contains the fiels
ActionID, AdvisorID and Date.
I want to retrieve, for each couple (action, advisor), the max date that can
be found in Forecasts, or NULL if the couple is not present in the Forecasts
I thought I would do it that way:
SELECT ActionID, AdvisorID, Max(Date) FROM Forecasts RIGHT OUTER JOIN
Actions ON Actions.ID = Forecasts.ActionID RIGHT OUTER JOIN Advisors ON
Advisors.ID = Forecasts.AdvisorID GROUP BY ActionID, AdvisorID
But for some reason that I'm not sure to understand, this seems to return
the same datas as (at least ...