View Single Post
Old 04-21-2005, 03:32 PM   #2 (permalink)
Bamrak
Enter Title Here
 
Location: Tennessee
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..
Bamrak is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57