Create relation between two transaction tables based on date column [ many to many ] issue

Need your help on a problem. I have two non-related transaction table and I need to show it's metrics on the dashboard with date silcer. How do I create date relationship between this tables since it...