Join Hint

Nested Loop
It is more a effective method then a merge Join when the data is small.

select *
from employee e inner loop join jobs j
on e.job_id = j.job_id

Sort Merge Join
It is more efficient in the most cases.

select *
from employee e inner merge join jobs j
on e.job_id = j.job_id

Hash Match Join
If you don't have any indexs or sorted data in a compare clue. SQL server use this method.
It is less efficient method.