I am trying to combine two tables. I want to find out how many products are underneath that category

Hi,

just looking at the documentation I'd try adding the return type of CustomTableItem.

docs.kentico.com/k10/...Joiningmultipletables(SQLJOIN)

as in:

var result =
 CustomTableItemProvider.GetItems("customtable.MyJoinCategory")
.Source(s => s.LeftJoin<CustomTableItem>
  ("customtable_MyJoinProduct", "ItemID", "CategoyID"))
.Result;

But it might also fail because of the ItemID column, as probably both your custom tables have this column.

So you might want to include the table name:

var result =
 CustomTableItemProvider.GetItems("customtable.MyJoinCategory")
.Source(s => s.LeftJoin<CustomTableItem>
  ("customtable_MyJoinProduct", "customtable_MyJoinProduct.ItemID", "CategoyID"))
.Result;

Hi David,

I can combine two tables. I can not find the total number of products under the category.

Samples

Category1 => Product 4 Count, Category2 => Product 2 Count, Category3 => Product 0 Count,

Thank you

In the query article is mentioned how to add a count column:

     .AddColumn(
         new CountColumn("CustomColunmnXYZ").As("ColunmnCount")
     )

https://devnet.kentico.com/articles/kentico-8-technology-dataquery-api

I think this should return the counters you need.

Hİ David

sorry, I did not understand.

var result = CustomTableItemProvider.GetItems("customtable.MyJoinCategory").Source(s => s.LeftJoin("customtable_MyJoinProduct", "ItemID", "CategoyID")).Result;

?