I have a referenced table question.
I have an app that has lead information in it. I have another table that has tasks that reference the organization in the leads table. The tasks are timestamped, but the task table contains multiple tasks for each organization.
What I want to do is add a column to the leads table that contains the most recent task timestamp from the tasks table. This is so I can have this as a column for sorting in my leads table view.
Iโve tried several things and canโt quite figure out the best way to do this. Does anyone have advice?
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |