Proofdada
Bewarse Legend Username: Proofdada
Post Number: 145605 Registered: 03-2004 Posted From: 71.170.93.71
Rating: N/A Votes: 0 | Posted on Monday, March 07, 2016 - 8:48 pm: | |
select *(idhi emanna kavachu) from [JobCenter3R2Prod].[dbo].[Projects] as a left join [JobCenter3R2Prod].[dbo].[ProjectMilestones] as b on b.projectid = a.projectid and year( max(b.milestonedate)) = 2015 ilaa rayacha? |