|
stepson
Yak Posting Veteran
Romania
85 Posts |
 Posted - 11/22/2012 : 01:19:12
|
Hi,
on what base do you select 400 at Forecast ?
-because is max or what ?
; with B
as (
select 7 as [Month],465318 as Code, 300 as budget union all
select 9 as [Month],465318 as Code, 300 as budget
),
F as (
select 5 as [MOnth], 465318 as Code ,400 as ForeCast union all
select 6 as [MOnth], 465318 as Code ,100 as ForeCast union all
select 7 as [MOnth], 465318 as Code ,200 as ForeCast
)
select B.*,F.foreCast
from B inner join
(select code, max(ForeCAst) as ForeCast from F
group by code )F on B.code=F.code
Ce-am pe mine am si-n dulap, cand ma-mbrac zici ca ma mut
sabinWeb |
 |
|
Combining two tables
