Inner Join

SQL Server Query

            
SELECT P.ProductName, S.CompanyName AS SupplierName, C.CategoryName, P.UnitPrice  

FROM Products P   

INNER JOIN Suppliers S ON P.SupplierID = S.SupplierID  

INNER JOIN Categories C ON P.CategoryID = C.CategoryID; 

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

   .Select()  

  .Column("P.ProductName", "ProductName")  

  .Column("S.CompanyName", "SupplierName")  

  .Column("C.CategoryName", "CategoryName")  

  .Column("P.UnitPrice", "UnitPrice")  

  .From("Products", "P")  

   .Join(new List<IJoin>()  

   {  

      new INNERJOIN().TableName("Suppliers","S")  

        .On(new Column("P.SupplierID").Equale(new Column("S.SupplierID"))),  

      new INNERJOIN().TableName("Categories","C")  

        .On(new Column("P.CategoryID").Equale(new Column("C.CategoryID")))  

   }) 

   .Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT P.ProductName AS ProductName,
       S.CompanyName AS SupplierName,
       C.CategoryName AS CategoryName,
       P.UnitPrice AS UnitPrice
FROM Products AS P
     INNER JOIN
     Suppliers AS S
     ON P.SupplierID = S.SupplierID
     INNER JOIN
     Categories AS C
     ON P.CategoryID = C.CategoryID;


            
        

Parameters (If used)

Query Results: