[Solved] Which of the following is the correct syntax to combine two SELECT queries using UNION in SQL? — Ans: SELECT * FROM table1 UNION SELECT * FROM table2; | SQL

SQL - Set Operations

Which of the following is the correct syntax to combine two SELECT queries using UNION in SQL?

AUNION SELECT * FROM table1, SELECT * FROM table2;

BSELECT * FROM table1 JOIN UNION SELECT * FROM table2;

CSELECT * FROM table1 UNION SELECT * FROM table2;

DSELECT * FROM table1 AND SELECT * FROM table2 UNION;

Step-by-Step Solution

Solution:

Step 1: Recall correct UNION syntax
The correct syntax is to write one SELECT query, then UNION, then another SELECT query.
Step 2: Check each option for syntax errors
SELECT * FROM table1 UNION SELECT * FROM table2; follows the correct syntax. Options A, B, and D have incorrect keywords or order.
Final Answer:
SELECT * FROM table1 UNION SELECT * FROM table2; -> Option C
Quick Check:
Correct UNION syntax = SELECT * FROM table1 UNION SELECT * FROM table2; [OK]

Quick Trick: UNION joins two SELECT queries directly [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax to combine two SELECT queries using UNION in SQL?