how to fetch data from two tables using single query

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