Postgresql column reference "id" is ambiguous

Question

I tried the following select:

SELECT (id,name) FROM v_groups vg  inner join people2v_groups p2vg on vg.id = p2vg.v_group_id where p2vg.people_id =0; 

and I get the following error column reference id is ambiguous.

Thing is if I try the same SELECT but I only ask for name, and not for id also, it works. I'm new to this and maybe I am missing something obvious. Any suggestions?

Thanks.

Answer 1

You need the table name/alias in the SELECT part (maybe (vg.id, name)) :

SELECT (vg.id, name) FROM v_groups vg  inner join people2v_groups p2vg on vg.id = p2vg.v_group_id where p2vg.people_id =0;