Is this a valid query?

[Ndi Ekpenyong]

Is this a valid select statement in mysql :

SELECT * FROM table1 as t1, table2 as t2 WHERE t1.id=t2.id;

Or am i supposed to list all the columns i wish to retrieve e.g SELECT t1.nameas name, t1.dob as dob, t1.address as address, t2.salary as salary, t2.dept as dept FROM table1 as t1, table2 as t2 WHERE t1.id=t2.id;