What I did was to create 2 derived tables on for each of the actuals. then joined them together for a finial output. The other (orginal) could work I just don't have the time to recreate all the tables and work it out. I don't use MySQL so it is based generic SQL Ansi code