[Solved] You wrote this SQL query:SELECT * FROM table1 UNION table2;What is the error and how to fix it? — Ans: Missing SELECT before table2; fix by adding SELECT * FROM table2 | SQL

SQL - Set Operations

You wrote this SQL query:
SELECT * FROM table1 UNION table2;
What is the error and how to fix it?

AMissing SELECT before table2; fix by adding SELECT * FROM table2

BUNION cannot be used with tables; use JOIN instead

CUNION requires parentheses around queries

DNo error; query runs fine

Step-by-Step Solution

Solution:

Step 1: Identify syntax error in UNION usage
UNION requires two complete SELECT statements, but second query lacks SELECT.
Step 2: Correct the query syntax
Add SELECT * FROM before table2 to fix the error.
Final Answer:
Missing SELECT before table2; fix by adding SELECT * FROM table2 -> Option A
Quick Check:
UNION needs two SELECTs [OK]

Quick Trick: UNION needs two full SELECT queries [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

You wrote this SQL query: