How do I query table B to count how many rows have...

# exposed

[galex]

How do I query table B to count how many rows have my id from Table A? Basically a calculated field based on another select?

[tapac]

Could you express it with a plain sql?

[galex]

Yes, something like “Select count(*) as countStuff from TableB b where b.id = a.id” inside another query

[tapac]

TableA.innerJoin(TableB, { TableA.id }, { TableB.id }).
   slice(TableA.id.count()).
   selectAll()

?

[galex]

I will try that, thanks