Self Join

SQL Server Query

            
SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia,  

Orders.Freight, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry,  

[Order Details].OrderID, [Order Details].ProductID, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount 

FROM Orders, [Order Details]  

WHERE Orders.OrderID = [Order Details].OrderID;  

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

 .Select()  

  .Columns("Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia")  

  .Columns("Orders.Freight, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry")  

  .Columns("[Order Details].ProductID, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount") 

  .From("Orders").From("[Order Details]")  

  .Where(new Where(new Column("Orders.OrderID").Equale(new Column("[Order Details].OrderID"))))  

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT Orders.OrderID,
       Orders.CustomerID,
       Orders.EmployeeID,
       Orders.OrderDate,
       Orders.RequiredDate,
       Orders.ShippedDate,
       Orders.ShipVia,
       Orders.Freight,
       Orders.ShipAddress,
       Orders.ShipCity,
       Orders.ShipRegion,
       Orders.ShipPostalCode,
       Orders.ShipCountry,
       [Order Details].ProductID,
       [Order Details].UnitPrice,
       [Order Details].Quantity,
       [Order Details].Discount
FROM Orders, [Order Details]
WHERE Orders.OrderID = [Order Details].OrderID;


            
        

Parameters (If used)

Query Results: