Proofdada
Bewarse Legend Username: Proofdada
Post Number: 145613 Registered: 03-2004 Posted From: 71.170.93.71
Rating: N/A Votes: 0 | Posted on Monday, March 07, 2016 - 9:06 pm: | |
elect a.ProjectID from [JobCenter3R2Prod].[dbo].[Projects] as a left join [JobCenter3R2Prod].[dbo].[ProjectMilestones] as b on a.[ProjectID] = b.[ProjectID] group by a.ProjectID having year( max(b.MilestoneDate)) = 2015 idhi work out ayyindhi... mee mohala manda... okkadki sql radha... vachi... |