Which of the following is the correct syntax for a non-equi join using the '<' operator between tables A and B on column x?

easy📝 Syntax Q3 of 15

SQL - Advanced Joins

ASELECT * FROM A, B WHERE A.x = B.x;

BSELECT * FROM A JOIN B WHERE A.x < B.x;

CSELECT * FROM A JOIN B ON A.x < B.x;

DSELECT * FROM A JOIN B ON A.x = B.x;

Step-by-Step Solution

Solution:

Step 1: Understand JOIN syntax
JOIN requires ON clause to specify join condition, including non-equi conditions.
Step 2: Identify correct use of '<' in ON clause
Using ON A.x < B.x is valid for non-equi join; WHERE clause is not for join conditions.
Final Answer:
SELECT * FROM A JOIN B ON A.x < B.x; -> Option C
Quick Check:
Non-equi join syntax uses ON with comparison [OK]

Quick Trick: Use ON with comparison operators for non-equi joins [OK]

Common Mistakes:

MISTAKES

Master "Advanced Joins" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes