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. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  31. Case in Select Statement
  32. Self Join to get employee manager name
  33. How can I do an UPDATE statement with JOIN in SQL Server?
  34. How do I use properly CASE..WHEN in MySQL
  35. Must declare the scalar variable
  36. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  37. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  38. Case statement in MySQL
  39. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  40. Drop a temporary table if it exists
  41. ORA-00918: column ambiguously defined in SELECT *
  42. IDENTITY_INSERT is set to OFF – How to turn it ON?
  43. How to reset AUTO_INCREMENT in MySQL
  44. How do I limit the number of rows returned by an Oracle query after ordering?
  45. MySQL: Invalid use of group function
  46. Compare dates in MySQL
  47. Get day of week in SQL Server 2005/2008
  48. incorrect syntax error CREATE VIEW must be the only statement in the batch
  49. PLS-00103: Encountered the symbol when expecting one of the following:
  50. MySQL Error 1264: out of range value for column
  51. How do you create a temporary table in an Oracle database?
  52. Oracle SQL: Update a table with data from another table
  53. How to SUM and SUBTRACT using SQL?
  54. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  55. Sql query to insert datetime in SQL Server
  56. How to divide two columns?
  57. MySQL starts with searching issue
  58. SQL Parentheses use in an OR clause
  59. Is it possible to GROUP BY multiple columns using MySQL?
  60. SQL “select where not in subquery” returns no results
  61. ListAGG in SQLSERVER
  62. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  63. Best way to test if a row exists in a MySQL table
  64. Get current year in TSQL
  65. Is it possible to specify condition in Count()?
  66. SQL Server: Make all UPPER case to Proper Case/Title Case
  67. How do I query for all dates greater than a certain date in SQL Server?
  68. Temporary table in SQL server causing ‘ There is already an object named’ error
  69. Oracle: If Table Exists
  70. Equivalent of explode() to work with strings in MySQL
  71. MySQL OPTIMIZE all tables?
  72. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  73. How do I count unique items in field in Access query?
  74. Append table to an existing one: SQL Server
  75. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  76. “select * into table” Will it work for inserting data into existing table
  77. ORA-01735: invalid ALTER TABLE option – Toad
  78. CASE IN statement with multiple values
  79. Update query using Subquery in Sql Server
  80. List of special characters for SQL LIKE clause
  81. “This SqlTransaction has completed; it is no longer usable.”… configuration error?
  82. register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
  83. prepare() not working
  84. How do I move a WordPress site to another server?
  85. Return number of items in a table with post id
  86. Debugging WordPress
  87. Pull data and display as rows and columns
  88. I need a SQL command to delete specific authors and all posts connected with them
  89. How can i restore only Blogs from a SQL backup file?
  90. DB_HOST – is LOCALHOST speedy than domain name? [closed]
  91. wpdb prepare sql problem
  92. How to change post published date to today date with SQL
  93. Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
  94. How do I display SQL query on a specific page of my wordpress site
  95. blank page after update my theme
  96. Sql query returns empty. But not
  97. SQL – JOIN last child
  98. Adding profile data to database
  99. How to get the sum of each post with the same date
  100. Deleting the MySQL database

Leave a Comment

tech