No, that would be the easy answer wouldn't it? :-)
If you select all the data from more than one table, you will have to tell SQL how to merge the data.
Remember, the SELECT statement will fetch all records that meet the WHERE clause requirements. If you do only
SELECT * FROM table1, table2, table3;
Then SQL has no WHERE clause, thus every record from every table matches every time.
That means that the database will return all possible combinations of all records in all tables: a cartesian product.
I suggest you read about the JOIN statement and how the LEFT JOIN works.