I need to create a an SQL query which takes the information from the main "Projects" table, and then uses column "WBS1" to join onto 3 other tables "AP","AR","EX".
The 3 AP,AR,EX tables have the information stored per transaction date.
The requirement is to return the sum(AP+AR+EX) Per WBS1 but for each calendar month.
It is also important that if there has been no transactions for the month , it returns <null> rather than 0
The attached PDF hopefully explains a little more.
thanks in advance