SQL INNER JOIN KEYWORD.

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 547  View(s)
Ratings:
Rate this:
how to use inner join in sqlserver please help me .
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: SQL INNER JOIN Keyword.

     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

     

     

     

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!