Thanks Davo
This worked thanks and its being generated via the backend rather then in moodle itself.
And now I have seen how to do it I can't believe how simple the solution was.
Much appreciated this has helped me a lot.
Scott
General developer forum
Mysql query joining 2 queries
This discussion has been locked so you can no longer reply to it.