Vidyalelo
MySQL · Q478

MySQL

Programming · MySQL · question 478

Q478

The clause that filters JOIN results is called . . . . . . . .

A.
WHERE
Answer
B.
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.