if OBJECT_ID('tempdb..#TableA') is not null

drop table #tableA

select * into #tableA from (

select dt='20090701', no=1111, prc=30000 union all

select dt='20090702', no=1112, prc=45000 union all

select dt='20090703', no=1113, prc=27500 union all

select dt='20090704', no=1114, prc=30000 union all

select dt='20090705', no=1115, prc=30000 union all

select dt='20090706', no=1116, prc=16000 union all

select dt='20090707', no=1117, prc=78000 union all

select dt='20090708', no=1118, prc=86000 union all

select dt='20090709', no=1119, prc=25000 union all

select dt='20090710', no=1120, prc=46000 union all

select dt='20090711', no=1121, prc=74000 union all

select dt='20090712', no=1122, prc=48000 union all

select dt='20090713', no=1123, prc=20000 union all

select dt='20090714', no=1124, prc=82000) a

if OBJECT_ID('tempdb..#tableB') is not null

drop table #tableB

select * into #tableB from (

select no=1111, dt='20090501' union all

select no=1111, dt='20090620' union all

select no=1111, dt='20090626' union all

select no=1112, dt='20090604' union all

select no=1112, dt='20090609' union all

select no=1112, dt='20090617' union all

select no=1112, dt='20090627' union all

select no=1112, dt='20090630' union all

select no=1122, dt='20090601' union all

select no=1122, dt='20090625' union all

select no=1122, dt='20090629' union all

select no=1122, dt='20090630' union all

select no=1123, dt='20090620' union all

select no=1123, dt='20090625' ) b

select a.no, a.prc, dt=isnull(b.dt, '-') from #tableA a

left outer join (

select no, dt = MAX(dt) from #tableB

group by no

) b

on a.no = b.no

order by a.no

아직 SQL에 익숙하지 않은지라 상당히 어렵게 보입니다만, 테스트 해 보겠습니다.

다시한번 감사의 말씀 올립니다.