Toad World

DearToadusers,

I'm struggling for several days now to get data from several queries on onereport page.

For now,I’ve advanced quite far, but I’m stuck in  trying to show all thedata from the query.

 I’musing the following query:

SELECT A60.selection as 'status',

      COUNT(*) as 'currentstatus' ,

      (SELECT COUNT(*) FROM p.vrk2060 B60 WHERE SUBSTRING(B60.selection,1,1) <= SUBSTRING(A60.selection,1,1)) as 'still to beprocessed'

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 beprocessed1'

FROM p.vrk2064 A64

group byA64.selection

orderby A64.selection;

I expectthat in to top part of the two, also other statuses would appear, because thedo 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 findthe solution, but unfortunately didn’t post it.