It seems to me that i can't figure out simple thing.
I have two tables
table 1 - tblMilestones ( PKMilestoneID-number, ProjectID, MilestoneDate,MilestoneTyp
table2 - tblTypesOfMilestones(PKMil
they have one to many relationships based on milestonetypeid.
I need to show The oldest Milestone per project.
But query should output ProjectId, MilestoneName and MilestoneDate
thanks for help.