|
Replies:
0
-
Pages:
1
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
4
Registered:
8/4/10
|
|
|
|
Toad Data Report, showing results from mulitple quiries
Posted:
Mar 1, 2011 2:03 AM
|
|
|
|
|
Dear Toadusers,
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!
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
