Full Outer Join

SQL Server Query

            
SELECT Customers.CompanyName, Orders.OrderID  

FROM Customers   

FULL OUTER JOIN Orders ON Customers.CustomerID=Orders.CustomerID;  

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

   .Select()  

  .Columns("Customers.CompanyName", "Orders.OrderID")  

  .From("Customers")  

   .Join(new List<IJoin>()  

   {  

      new FULLOUTERJOIN().TableName("Orders")  

          .On(new Column("Customers.CustomerID").Equale(new Column("Orders.CustomerID")))  

   }) 

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT Customers.CompanyName,
       Orders.OrderID
FROM Customers
     FULL OUTER JOIN
     Orders
     ON Customers.CustomerID = Orders.CustomerID;


            
        

Parameters (If used)

Query Results: