how to create view of two table contents?

Answer 1

select * from table1, table2 or select column.table1, column.table2 from table1, table2 where column.table1 = "john" .

Answer 2

write the select query first and if it is as per ur requirement just add create view as view_name