forum

home / developersection / forums / sql inner join keyword.

Ask Question

SQL INNER JOIN Keyword.

Anonymous User 1500 05-Nov-2015

how to use inner join in sqlserver please help me .

sql server

Updated on 05-Nov-2015

Anonymous User

Other

I am a content writter !

Can you answer this question?

Answer

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.

Anonymous User

Can you answer this question?

1 Answers

Liked By