Hi Marvin: Thank you for the tip - that was very helpful.
I will try to charm our DBA to create materialized view that will give what you suggested - with our data structure, running UNION on the fly creates latency (there are separate projects to clean up the database and LDAP schemas and move them to 21st century). I appreciate your help which saved me lots of time barking up the wrong tree - thank you. On Wed, May 23, 2012 at 12:58 PM, Marvin Addison <[email protected]>wrote: > > Due to the way the database data is setup, I have to initiate three > separate database 'SELECT' statements to retrieve the account attributes - > is this possible? > > First thing that comes to mind is to leverage the UNION operator to > consolidate multiple result sets into one. On most platforms the number of > selected columns must be the same, and in my experience the selected > columns must have the same name if I recall correctly. If you can meet the > first requirement, the second should be straightforward using column > aliases. Hopefully your database platform supports UNION. > > M > -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
