Left Join

SQL Server Query

            
SELECT Customers.CompanyName, Customers.ContactName, Customers.City, Customers.Phone, Orders.OrderID, Orders.ShipCity  

FROM Customers   

LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID  

ORDER BY Customers.ContactName; 

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

   .Select()  

  .Columns("Customers.CompanyName","Customers.ContactName","Customers.City","Customers.Phone")  

  .Columns("Orders.OrderID","Orders.ShipCity")  

  .From("Customers")  

   .Join(new List<IJoin>()  

   {  

      new LEFTJOIN().TableName("Orders")  

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

   }) 

   .OrderBy(new OrderBy().SetColumnAscending("Customers.ContactName")) 

   .Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT Customers.CompanyName,
       Customers.ContactName,
       Customers.City,
       Customers.Phone,
       Orders.OrderID,
       Orders.ShipCity
FROM Customers
     LEFT OUTER JOIN
     Orders
     ON Customers.CustomerID = Orders.CustomerID
ORDER BY Customers.ContactName ASC;


            
        

Parameters (If used)

Query Results: