У меня так получилось
create table #t1([id] char(5), code int, descr char(5))
insert into #t1 values('i1', 1, 'd1')
insert into #t1 values('i2', 2, 'd2')
insert into #t1 values('i3', 3, 'd3')

create table #t2([id] char(5), pole1 char(5), pole2 int)
insert into #t2 values('ii1', NULL, 1500)
insert into #t2 values('ii2', 'i2', 3000)
insert into #t2 values('ii3', 'i1', 2000)
insert into #t2 values('ii4', 'i1', 2000)
insert into #t2 values('ii5', 'i3', 2000)

create table #t3(idd char(5), docdef int, def char(5), descr char(5))
insert into #t3 values('ii1', 410, 'def1', 'ds1')
insert into #t3 values('ii2', 410, 'def2', null)
insert into #t3 values('ii3', 410, 'def3', '..')
insert into #t3 values('ii5', 410, 'def4', null)
insert into #t3 values('ip1', 430, 'def5', null)
insert into #t3 values('ip3', 430, 'def6', 'ds6')


SELECT #t2.[id], #t2.pole2,#t3.def,#t3.descr,#t1.descr
FROM #t2 LEFT OUTER JOIN #t1 ON #t1.[id] = #t2.pole1
INNER JOIN #t3 ON #t3.idd = #t2.id

go
drop table #t1
drop table #t2
drop table #t3