column "id" 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/* You need to specify which id you want in the view. */
SELECT table1.id, column2, column3, ... FROM table1, table2
WHERE table1.id = table2.id