A column that does a calculation from other table?

Hello once again, so as I am moving a bit further with my database structure the issues are becoming a little more complicated, but I definitely believe that it's still possible to do with xano!

So here's the situation, we have 2 tables
• Table A - accounts
• Table B - accountActions


Table A contains-id;date;email;password
Table B contains-id;email;action1,action2 ( so the actual data would look like this)
When user makes an action I would add a row with '1' for that column.
• 1; today ; [email protected];0;1
• 2; yesterday ; [email protected];0,1
• 3; last week ; [email protected];1;0


So my question is - how to get an account from table A by a sum of actions from table A 
Thanks for reading! [3oEdva9BUHPIs2SkGk.gif]
Other
8 replies