Difference between JOIN..AS and WHERE..condition for combining tables

Question

Hello
What is the benefit of JOIN two tables instead of just using WHERE?

Answer 1

If you use WHERE you will get two separate tables, adding join will merge those two separate tables into one