These are the tables that I have created: Tables I want to get accounts.account,accounts.type,DATE(transactions.date),transactions.transactionid,transactions.amount,transactions.note from two tables between ’10-11-2021′ and ’31-12-2021′.(whatever..