Create Inner Join Query In Mysql Database

In MySQL, you can use the INNER JOIN clause to combine data from two or more tables based on a common column. Here's the basic syntax:

SELECT column_name(s)
FROM table1
INNER JOIN table2 ON table1.column_name = table2.column_name;

Here's an example query that joins two tables:

SELECT orders.order_id, customers.customer_name
FROM orders
INNER JOIN customers ON orders.customer_id = customers.customer_id;

In this example, the query selects the order ID from the "orders" table and the customer name from the "customers" table, where the customer ID in the "orders" table matches the customer ID in the "customers" table. This will return a list of all orders with the corresponding customer name.

You can join more than two tables by adding additional INNER JOIN clauses to the query. For example:

SELECT orders.order_id, customers.customer_name, products.product_name
FROM orders
INNER JOIN customers ON orders.customer_id = customers.customer_id
INNER JOIN order_details ON orders.order_id = order_details.order_id
INNER JOIN products ON order_details.product_id = products.product_id;

In this example, the query joins four tables: "orders", "customers", "order_details", and "products". The query selects the order ID from the "orders" table, the customer name from the "customers" table, and the product name from the "products" table, where the order ID in the "orders" table matches the order ID in the "order_details" table, and the product ID in the "order_details" table matches the product ID in the "products" table. This will return a list of all orders with the corresponding customer name and product name.

• Twitter
• Facebook
• Google Plus

• Create Inner Join Query In Mysql Database