SQL INNER JOIN Keyword.

Anonymous User 1622 05 Nov 2015

how to use inner join in sqlserver please help me .

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 05 Nov 2015

The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables.

Syntax:

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

Example:
select a.CustomerID, b.CustomerName,b.ContactName,b.Address,b.City ,
b.Country,a.Orderdate,a.OrderID,a.amount from Customer b inner join [Order] a on a.customerID=b.CustomerID where b.CustomerID=1

forum

SQL INNER JOIN Keyword.

Can you answer this question?

1 Answers