SELECT * FROM table1, table2
SELECT table1.column1, table1.column2, table2.column1 FROM table1, table2
This is called cross product in SQL it is same as cross product in sets
These statements return the selected columns from multiple tables in one query.
There is no specific relationship between the columns returned from each table.