Sounds crazy I know. But currently I do have a program called Forest and Trees that uses Views much like TDA uses editors, however, each “view” can see each other based on the view name. I can query 2 views with a 3rd view as if the first two views were independent tables.
So, Forest and Trees is no longer supported (either by the company CA or our company) so I need to transition this monster report to TDA. I am trying to figure out how the heck I am going to accomplish this. I am not strong with Macro’s so that would be a learning curve for me.
I am not sure if I can do this but if I were to run the first 6 queries can I combine them into a final query that refernces the first 6? Iam truly not sure how this would look, but I gave it a novice attempt below.
So select * from customers where blah blah; A,select * from orders where blah blah; B,select * from order_lines where blah blah; C,select * from a, b, c where a.id = b.id and b.id = c.id
Excuse me for my lack of knowledge on this subject. Not sure how you would reference multiple queries.
P.S. I can’t do this with a JOIN, the data will not mash together properly with the current DB setup I am pulling from, they need to be individual queries, been there done that.