Q478
The clause that filters JOIN results is called . . . . . . . .
A.
WHERE
AnswerB.
SORT
C.
GROUP
D.
GROUP BY
Answer: Option A
Solution
Answer: Option A
Solution:
Imagine you have two tables, one with customer information and another with their orders. When you want to combine these tables, you use a JOIN to connect related data.Now, if you want to show only the orders placed by customers in a specific city, you need to filter the results. This is where the WHERE clause comes in. It acts like a filter, letting you select only the rows that meet a certain condition.
So, the answer is Option A: WHERE.