Explain the difference between a left join and an inner join, and describe a scenario where using the wrong join would corrupt financial reporting at Mufg - Mitsubishi Ufj Financial Group.
Use the provided tables to produce the January 2025 report for active accounts. The query should retain active accounts with no qualifying transactions so the result demonstrates the reporting impact of choosing the wrong join.
account_id, account_name, posted_transaction_count, and posted_amount.account_id ascending.| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique account identifier |
| account_name | VARCHAR(100) | Reporting name of the account |
| account_type | VARCHAR(30) | Account classification |
| account_status | VARCHAR(20) | Current account status |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| account_id | INT | Account associated with the transaction |
| transaction_date | DATE | Transaction posting date |
| amount | DECIMAL(14,2) | Transaction amount in reporting currency |
| transaction_status | VARCHAR(20) | Transaction processing status |