-
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’;
-
- No
- Depends
- Yes
- All of above
- None of these
Correct Option: C
In the following query there are two equality conditions “ON” and “WHERE”.