Implicit Inner Join in SQL server

Question

I want to know how to work with implicit inner join in SQL server.

Thank you.