Postgresql column reference “id” is ambiguous

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;

Related Posts:

  1. How do I UPDATE from a SELECT in SQL Server?
  2. SQL SELECT WHERE field contains words
  3. SQL SELECT WHERE field contains words
  4. SQL SELECT WHERE field contains words
  5. ORA-01843 not a valid month- Comparing Dates
  6. Best way to do nested case statement logic in SQL Server
  7. missing FROM-clause entry for table
  8. Insert text with single quotes in PostgreSQL
  9. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  10. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  11. Postgresql tables exists, but getting “relation does not exist” when querying
  12. postgresql: error duplicate key value violates unique constraint
  13. pg_ctl: no database directory specified and environment variable PGDATA unset
  14. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  15. Postgres Error: More than one row returned by a subquery used as an expression
  16. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  17. SQL: Two select statements in one query
  18. SQL conditional SELECT
  19. PostgreSQL create table if not exists
  20. updating table rows in postgres using subquery
  21. PostgreSQL visual interface similar to phpMyAdmin?
  22. DATEDIFF function in Oracle
  23. GROUP BY and COUNT using ActiveRecord
  24. MySQL error: Unknown column in ‘where clause’
  25. How to order by column A and then by column B?
  26. What is a postgres superuser
  27. Help me SELECT thumbnail from SQL and use
  28. how to SELECT meta values that are not null?
  29. What’s the best way to search for a UPC code in a Database?
  30. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  31. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  32. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  33. What is the difference between UNION and UNION ALL?
  34. Selecting COUNT(*) with DISTINCT
  35. Case in Select Statement
  36. What is a stored procedure?
  37. ORA-00904: invalid identifier
  38. SQL WITH clause example [duplicate]
  39. Unknown column in ‘field list’ error on MySQL Update query
  40. Unknown column in ‘field list’ error on MySQL Update query
  41. SQL Inner-join with 3 tables?
  42. The wait operation timed out. ASP
  43. What is SELF JOIN and when would you use it? [duplicate]
  44. The wait operation timed out. ASP
  45. Conversion failed when converting date and/or time from character string while inserting datetime
  46. Self Join to get employee manager name
  47. how to fix oracle ORA-01722 invalid number error
  48. SQL query to select dates between two dates
  49. MySQL – Operand should contain 1 column(s)
  50. Conversion failed when converting date and/or time from character string while inserting datetime
  51. When should I use CROSS APPLY over INNER JOIN?
  52. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  53. Insert Data Into Temp Table with Query
  54. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  55. SQL query to get the employee name and their manager name from the same table
  56. MySQL create table if not exists and insert record only if table was created
  57. error, string or binary data would be truncated when trying to insert
  58. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  59. NOT IN vs NOT EXISTS
  60. Online SQL Query Syntax Checker
  61. How can I do an UPDATE statement with JOIN in SQL Server?
  62. Must declare the scalar variable
  63. ORA-00979 not a group by expression
  64. ORA-00907: missing right parenthesis
  65. How do I use properly CASE..WHEN in MySQL
  66. Must declare the scalar variable
  67. Rename column SQL Server 2008
  68. Why do we need “Relationships” between tables at all?
  69. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  70. Using group by on multiple columns
  71. Efficiently convert rows to columns in sql server
  72. How can I do a FULL OUTER JOIN in MySQL?
  73. Nested select statement in SQL Server
  74. PostgreSQL “DESCRIBE TABLE”
  75. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  76. Using group by on multiple columns
  77. MySQL query String contains
  78. How do I escape a single quote in SQL Server?
  79. What’s the difference between VARCHAR and CHAR?
  80. Case statement in MySQL
  81. T-SQL split string based on delimiter
  82. How to declare a variable in MySQL?
  83. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  84. Finding duplicate values in a SQL table
  85. MySQL Cannot Add Foreign Key Constraint
  86. Drop a temporary table if it exists
  87. How do I escape a single quote in SQL Server?
  88. ORA-00918: column ambiguously defined in SELECT *
  89. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  90. How Stuff and ‘For Xml Path’ work in SQL Server?
  91. IDENTITY_INSERT is set to OFF – How to turn it ON?
  92. SQL update from one Table to another based on a ID match
  93. Oracle error : ORA-00905: Missing keyword
  94. How to split the name string in mysql?
  95. How to reset AUTO_INCREMENT in MySQL
  96. How do I import an SQL file using the command line in MySQL?
  97. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  98. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  99. mysql Foreign key constraint is incorrectly formed error
  100. How do I limit the number of rows returned by an Oracle query after ordering?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)