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;
More Related Contents:
- SQL SELECT speed int vs varchar
- Are there any way to execute a query inside the string value (like eval) in PostgreSQL?
- Why postgres returns unordered data in select query, after updation of row?
- How to return result of a SELECT inside a function in PostgreSQL?
- Possible to perform cross-database queries with PostgreSQL?
- Reset auto increment counter in postgres
- JOIN two SELECT statement results
- SQL Query to get aggregated result in comma separators along with group by column in SQL Server
- GROUP BY and aggregate sequential numeric values
- Safely rename tables using serial primary key columns
- How to use (install) dblink in PostgreSQL?
- get JOIN table as array of results with PostgreSQL/NodeJS
- updating table rows in postgres using subquery
- How can I send email from PostgreSQL trigger?
- Find overlapping date ranges in PostgreSQL
- Postgres manually alter sequence
- How to delete from select in MySQL?
- What’s the proper index for querying structures in arrays in Postgres jsonb?
- “Operator does not exist: integer =?” when using Postgres
- Postgres sql insert query syntax error from phpPgAdmin
- PostgreSQL convert columns to rows? Transpose?
- Does Postgres support nested or autonomous transactions?
- PostgreSQL delete with inner join
- Regular expression in PostgreSQL LIKE clause
- Why is iterating through a large Django QuerySet consuming massive amounts of memory?
- Update a column of a table with a column of another table in PostgreSQL
- Check if NULL exists in Postgres array
- Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
- How to use SQL LIKE condition with multiple values in PostgreSQL?
- Is there a postgres CLOSEST operator?