how to retrieve data from two tables with one sql statement without join

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