The only difference I can see is the order of the fields. In the first SELECT, they will be in order Test_Financing - Tip while it will be the inverse in the second SELECT, Tip - Test_Financing.

>I am assuming these 2 statements are functionally equivalent. Am I correct?
>Thanks
>

>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 
>