[Solved] Which of the following is the correct syntax for an INNER JOIN with table aliases? — Ans: SELECT a.name, b.salary FROM employees a INNER JOIN salaries b ON a.id =... | SQL

SQL - INNER JOIN

Which of the following is the correct syntax for an INNER JOIN with table aliases?

ASELECT a.name, b.salary FROM employees a INNER JOIN salaries b ON a.id = b.emp_id;

BSELECT a.name, b.salary FROM employees AS a JOIN salaries b WHERE a.id = b.emp_id;

CSELECT a.name, b.salary FROM employees a INNER JOIN salaries b USING a.id = b.emp_id;

DSELECT a.name, b.salary FROM employees a JOIN salaries b ON a.id == b.emp_id;

Step-by-Step Solution

Solution:

Step 1: Check INNER JOIN syntax
Correct syntax uses INNER JOIN with ON clause for join condition.
Step 2: Validate alias usage and condition
Aliases 'a' and 'b' are used correctly; ON clause uses single '=' for comparison.
Final Answer:
SELECT a.name, b.salary FROM employees a INNER JOIN salaries b ON a.id = b.emp_id; -> Option A
Quick Check:
INNER JOIN + ON + aliases = correct syntax [OK]

Quick Trick: Use ON with single = for join condition [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax for an INNER JOIN with table aliases?