-- prepare sample data
create table #Process (ProcessID int, ProcessName char(20), version int)
create table #Items (ItemID int, ProcessID int, ItemName char(20))

insert	#Process
select	101, 'Process1', 1 union all
select	102, 'Process2', 1 union all
select	103, 'Process3', 1 union all
select	104, 'Process1', 2 union all
select	105, 'Process1', 3

insert #Items
select 900, 101, 'Item1' union all
select 901, 101, 'Item2' union all
select 902, 102, 'Item3' union all
select 903, 103, 'Item4' union all
select 904, 101, 'Item5' union all
select 905, 102, 'Item6' union all
select 906, 103, 'Item7' union all
select 907, 104, 'Item8' union all
select 908, 103, 'Item9' union all
select 909, 102, 'Item10' union all
select 910, 103, 'Item11' union all
select 911, 105, 'Item12' union all
select 912, 105, 'Item13' 

select itemid, itemname from #items
inner join

--get the latest process info
	(select 
	processid
	from 
	#Process
	inner join
	(select
	processname,
	max(version) as version
	from #process
	group by processname) as maxvalues
	on #Process.processname = maxvalues.processname
	and #Process.version = maxvalues.version) as latestprocesses

on #items.processid = latestprocesses.processid

drop table #process
drop table #items

SELECT		i.ItemID,
		i.ItemName
FROM		#Items AS i
INNER JOIN	(
			SELECT	ProcessID,
				ROW_NUMBER() OVER (PARTITION BY ProcessName ORDER BY Version DESC) AS RecID
			FROM	#Process
		) AS x ON x.ProcessID = i.ProcessID
WHERE		x.RecID = 1