Home » MYSQL » Mysql miscellaneous » Question
  1. 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”.



Your comments will be displayed only after manual approval.