Vidyalelo
MySQL · Q980

MySQL

Programming · MySQL · question 980

Q980

In inner join, result is produced by matching rows in one table with rows in another table.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about inner joins in MySQL.
An inner join combines data from two or more tables based on a matching condition.
Imagine you have two tables:
* Customers: Contains information about your customers like their name, address, and ID.
* Orders: Contains information about the orders placed by customers, including the order date and the customer ID.

An inner join would help you get a list of customers and their orders by finding matching customer IDs in both tables.

So, the answer to the question is Option A: True.

An inner join does produce results by matching rows in one table with rows in another table based on a common column (like customer ID in our example).