ERROR: column "id" specified more than once

Ham-Solo answered on February 1, 2021 Popularity 5/10 Helpfulness 1/10

answer ERROR: column "id" specified more than once

Comment

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

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

Popularity 5/10 Helpfulness 1/10 Language sql

Tags: sql

Link to this answer
Share Copy Link

Contributed on Feb 01 2021

Ham-Solo

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.