Gochi
Censor Bewarse Username: Gochi
Post Number: 86937 Registered: 07-2004 Posted From: 64.121.82.184
Rating: N/A Votes: 0 | Posted on Monday, March 07, 2016 - 9:28 pm: | |
select * from [JobCenter3R2Prod].[dbo].[Projects] as a left join (select projectid, max(milestonedate) max_date from [JobCenter3R2Prod].[dbo].[ProjectMilestones] group by projectid) as b on a.projectid = b.projectid and year(b.max_date) = 2015 ittaa dobbinchukovali.. |