how to join columns of two tables in sql

how to fetch data from two tables in mysql without join?