Is there any way to append data together when a subquery isn't returning results. I've noticed that if the master query doesn't return results, then the data from the other subqueries is shown incorrectly.
-Alex
Hi Alex,
You can try using full outer join, which should return all of the results.
However full outer joins are not support by all databases, so you may like to view this forum for an alternative: Progress does not support a Full Outer Join
Let me know how you go.
Regards,
Steven