What is the best way to load 2 seperate tables to a single matrix

[Former Member]

What I would like to do is create a date sorted list of customer orders and purchase orders for a single item(part) and populate a single matrix.

and did i mention quick...

[AlexGrebennikov · Accepted solution]

Hi!

i suppose you sould create for example UNION query:

SELECT docdate, cardname, 'purch', docnum FROM OPCH
UNION
SELECT docdate, cardname, 'order', docnum FROM OPOR
ORDER BY 1

Then execute oRS.DoQuery and populate your matrix inside a loop...

propably, somebody can give you some more advices..

hope it helps..

[Former Member · Accepted solution]

Thanks for the info Alexey I will try your solution.. Thanks

[Former Member · Accepted solution]

Hmmm coulnt get the union statement to work even in query wizard. has anyone done anything similar? maybee joining to recordsets Can they be added(joined) together??

[Former Member · Accepted solution]

try your union query in a stored proc and call the stored proc from the query

Indika

[Former Member · Accepted solution]

Indika. That did it also solved the issue of sorting by date I was worried that an additional quicksort would slow things down too much . Creating a stored Proc provided both solutions

Thank you