Currently we have an Application selecting Data from QVD files (one per Table).
Please look at the following:
Orders: LOAD * FROM orders.qvd (qvd);
Positions: LOAD * FROM positions.qvd (qvd);
Currently this also selects positions that have no correlating orders, what I'd like to do is restrict the positions load to only those with an order_id located in the id-column of the Orders table.
The first thing coming to my mind is concatenating all entries in the Orders.Id Column to a large string and in the next step filtering by this string using where order_id in. But then again, there should be a more native way of doing this in QV, shouldn't there?