select * from table1 AND table2;

Question

select * from table1 AND table2;
Is this show the two tables?

Answer 1

eg:
select tb1.id,tb2.name from table1 tb1
left join table2 tb2
on tb1.id = tb2.main_id

Answer 2

you can also use

select * from table1
union all
select * from table2

buttable fields must ne the same (number and type)

Answer 3

No, The syntax is wrong....