I'm struggling for several days now to get data from several queries on one report page. For now, I’ve advanced quite far, but I’m stuck in trying to show all the data from the query.
I’m using the following query:
SELECT A60.selection as 'status', COUNT(*) as 'current status' , (SELECT COUNT(*) FROM p.vrk2060 B60 WHERE SUBSTRING(B60.selection,1,1) <= SUBSTRING(A60.selection,1,1)) as 'still to be processed' FROM p.vrk2060 A60 group by A60.p order by A60.p;
SELECT A64.selection as 'status1', COUNT(*) as 'current status1' , (SELECT COUNT(*) FROM p.vrk2064 B64 WHERE SUBSTRING(B64.selection,1,1) <= SUBSTRING(A64.selection,1,1)) as 'still to be processed1' FROM p.vrk2064 A64 group byA64.selection orderby A64.selection;
I expect that in to top part of the two, also other statuses would appear, because the do exist in the table. I’ve found someone who had the same problem I think: http://toadformysql.com/message.jspa?messageID=95755#95755 He did find the solution, but unfortunately didn’t post it.
If anyone needs more information, please let me know, any help will be greatly appreciated!