sql error column specified more than once code example

Example: ERROR: column "id" specified more than once

/* You need to specify which id you want in the view. */

SELECT table1.id, column2, column3, ... FROM table1, table2 
WHERE table1.id = table2.id