Creating adhoc view from two or more VIEWS
Posted on April 9, 2018 at 7:36am
How can I create an ad hoc view from morethan one VIEW? e.g if I have a view for STAFF biographical and another view for Staff Annual leave, how do I get data from the two VIEWS?
Joined: Apr 9 2018 - 7:27am
Last seen: 5 years 5 months ago
Posted on April 12, 2018 at 3:24am
Hi,
You can create multiple (two in your case) 'Derived tables' using the view queries within the domain that is driving your adhoc view and you should have both available. Hope this helps.
Thanks.
Joined: Nov 3 2017 - 3:11am
Last seen: 5 years 4 months ago
