A column that does a calculation from other table?
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