Right Join

SQL Server Query

            
SELECT od.OrderID, od.UnitPrice, od.Quantity, od.Discount, p.ProductName, p.QuantityPerUnit, p.UnitPrice, p.Discontinued  

FROM "Order Details" AS od   

RIGHT JOIN Products AS p ON od.ProductID = p.ProductID;  

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

   .Select()  

  .Columns("od.OrderID","od.UnitPrice","Quantity","Discount","ProductName","QuantityPerUnit","p.Discontinued")  

  .From("[Order Details]", "od")  

   .Join(new List<IJoin>()  

   {  

      new RIGHTJOIN().TableName("Products", "p")  

          .On(new Column("od.ProductID").Equale(new Column("p.ProductID")))  

   }) 

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT od.OrderID,
       od.UnitPrice,
       Quantity,
       Discount,
       ProductName,
       QuantityPerUnit,
       p.Discontinued
FROM [Order Details] AS od
     RIGHT OUTER JOIN
     Products AS p
     ON od.ProductID = p.ProductID;


            
        

Parameters (If used)

Query Results: