sql sever inner join

SQL Server INNER JOIN is used to combine rows from two or more tables based on a related column between them. The syntax for INNER JOIN is as follows:

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

Here, `table1` and `table2` are the names of the tables that you want to join, and `column` is the column that both tables have in common. The `ON` keyword is used to specify the condition that determines which rows from each table are matched.

For example, if you have two tables `orders` and `customers`, and you want to join them based on the `customer_id` column, you could use the following SQL query:

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

This would return a list of all orders and their corresponding customer names, where the customer ID in the orders table matches the customer ID in the customers table.