Hi all,
I have problem displaying the queries from the tables below, which I have 3 tables (Project, Period and Transaction) with the following schema
Table Project
- ProjectID
- ProjectName
Table Period
- PeriodID
- Month
- Year
Table Transaction
- TransactionID
- ProjectID (FK)
- PeriodID (FK)
- Transaction Value
The problem is I want to display all the transaction (with / without values) for every project and every period, so far all I got was transactions with values, I couldnt pull out the transaction without values, therefore I failed creating pivot table for the transaction.
I know it's simple but it's killing me
Please help to advise.