SQL INNER JOIN Script Query

See more:

SQL-Server

I am taking over a colleagues script and having problems understanding it. What does this script do?

from Finance.dbo.vtbl_orbt sal

inner join Finance.dbo.tbl_Period_Lookup ht on ht.Current_Period = @Current_Period

where sal.SGPERI between ht.P_Minus_30 and ht.Current_Period

Usually when I do a join, I would use an inner join to join on another table instead of another number.

from Finance.dbo.vtbl_orbt sal

inner join Finance.dbo.tbl_Period_Lookup ht on ht.Current_Period = sal.SGPERI

where sal.SGPERI between ht.P_Minus_30 and @Current_Period

Is there any difference from doing it this way? if so why do people do it the previous way?



Thanks for any help on this.