[Solved] How can you combine the VALUES clause with a JOIN to match inline data with an existing table users(id, name)? | PostgreSQL

PostgreSQL - Set Operations and Advanced Queries

How can you combine the VALUES clause with a JOIN to match inline data with an existing table users(id, name)?

ASELECT u.id, u.name, v.status FROM users u JOIN (VALUES 1, 'active', 2, 'inactive') AS v(id, status) ON u.id = v.id;

BSELECT u.id, u.name, v.status FROM users u, VALUES (1, 'active'), (2, 'inactive') AS v(id, status) WHERE u.id = v.id;

CSELECT u.id, u.name, v.status FROM users u JOIN VALUES (1, 'active'), (2, 'inactive') AS v(id, status) ON u.id = v.id;

DSELECT u.id, u.name, v.status FROM users u JOIN (VALUES (1, 'active'), (2, 'inactive')) AS v(id, status) ON u.id = v.id;

Step-by-Step Solution

Solution:

Step 1: Understand correct JOIN syntax with VALUES
SELECT u.id, u.name, v.status FROM users u JOIN (VALUES (1, 'active'), (2, 'inactive')) AS v(id, status) ON u.id = v.id; correctly wraps VALUES rows in parentheses and aliases columns, then joins on matching id.
Step 2: Identify errors in other options
SELECT u.id, u.name, v.status FROM users u, VALUES (1, 'active'), (2, 'inactive') AS v(id, status) WHERE u.id = v.id; uses comma join syntax incorrectly with VALUES. SELECT u.id, u.name, v.status FROM users u JOIN VALUES (1, 'active'), (2, 'inactive') AS v(id, status) ON u.id = v.id; misses parentheses around VALUES rows. SELECT u.id, u.name, v.status FROM users u JOIN (VALUES 1, 'active', 2, 'inactive') AS v(id, status) ON u.id = v.id; has incorrect VALUES syntax without proper row grouping.
Final Answer:
SELECT u.id, u.name, v.status FROM users u JOIN (VALUES (1, 'active'), (2, 'inactive')) AS v(id, status) ON u.id = v.id; -> Option D
Quick Check:
JOIN with VALUES needs parentheses and proper aliasing [OK]

Quick Trick: Use parentheses and alias columns when JOINing with VALUES [OK]

Common Mistakes:

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

How can you combine the VALUES clause with a JOIN to match inline data with an existing table users(id, name)?