HOW TO USE SQL FULL OUTER JOIN

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 660  View(s)
Ratings:
Rate this:
I Want to use Sql full outer join .please help me.
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: HOW TO USE SQL FULL OUTER JOIN

    The FULL OUTER JOIN keyword returns all rows from the left table (Customer) and from the right table ([Order]).
    The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins.

    SELECT column_name(s)
    FROM tbl1
    FULL OUTER JOIN tbl2
    ON tbl1.column_name=tbl2.column_name;

    Example

    SELECT Customer.CustomerID,Customer.CustomerName, [Order].OrderID,[Order].amount

    FROM Customer

    FULL OUTER JOIN [Order]

    ON Customer.CustomerID=[Order].CustomerID

    ORDER BY Customer.CustomerName;

     

Answer

NEWSLETTER

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