select a.air_nm_kor, b.start_pyun from ba014 a with(nolock), ( select distinct substring(start_pyun,1,2) as start_pyun from ev001 with(nolock) where good_type_cd = '9' and area_cd = '10' and good_yy = '2015' and good_seq = 7 and start_day >= convert(char(8), getdate(), 112) ) b where a.air_cd_short = b.start_pyun exec ONRSP_PRICE_MIN_MAX_TEST 9,10,2015,7========>psql
1,190,000원 ~