>>select * ; >>from test_financing ; >>inner join tip on test_financing.tip_id = tip.tip_id ; >>where between(_year,tipyear,tipyear+4) ; >>order by lead, st_name, _year >> >>select * ; >>from tip ; >>inner join test_financing on test_financing.tip_id = tip.tip_id ; >>where between(_year,tipyear,tipyear+4) ; >>order by lead, st_name, _year >>>