The relationships look good, here's your querys. it would also help to use a standard naming convention and give the query's descriptive names, or at least fill in the description. Your Queries are as follows:
Q1- you need a grouping to get rid of your duplicate rows.. like this:
SELECT Project.Name AS Project_Name, Milestone.Name AS Milestone_Name, Steps.Status_Complete
FROM (Milestone INNER JOIN Steps ON Milestone.MilestoneID = Steps.MilestoneID) INNER JOIN Project ON Milestone.MilestoneID = Project.MilestoneID
GROUP BY Project.Name, Milestone.Name, Steps.Status_Complete;
Q2- looks correct
Q3 also seems correct
Last edited by Bamrak; 04-21-2005 at 03:35 PM..
|