Timeline of activity

Hi,

I’m wanting to build a timeline of client activity that combines different activities from different database tables and show them in chronological order. For example combining bookings, transactions, tasks, emails and messages for a specific client, each have a unique ID within their respective tables (ie booking_id and transaction_id)

At the moment I can do it separately using repeating rows, but not sure how to combine them. Is there a custom sql query to map different tables into one table for example have a booking_id and transaction_id map to activity_id, then the different created date columns to a activity_created column and then use that to show all the different activities in time order?

Hope you can help.