How to select multiple query ??

Answer 1

You have a few options you can select from multiple tables

FROM table1, table2

The better way is to use JOIN, which you can find in the lessons.

Answer 2

select column_list from table_name;
select column_list (another column list) from table_name(same table name) ;

Answer 3

example with JOIN:
SELECT a.column_1, b.column_2 FROM table_1 a
JOIN table_2 b ON (a.id=b.id)

example with UNION:
SELECT id, name FROM table_1
UNION
SELECT id, name FROM table_2