Is the following query belongs to the “Equality condition”?SELECT

Home » MYSQL » Mysql miscellaneous » Question

Is the following query belongs to the “Equality condition”?

SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name=’customers_accounts’;

1. No
2. Depends
3. Yes
4. All of above
5. None of these

Correct Option: C

In the following query there are two equality conditions “ON” and “WHERE”.