Is it possible to build Query on workbook?
ie: Is it possible to summarize the results of two querys and to display the result in another query.
Problem: Due to wrong definition of field the data get overflowed and results in sql error in query.
Now if i change the field definition thant its a risky process due to the data presence for field in different target.
Instead of that i have planned to built two queries with different selection and summarize the result in third query and attach the third query in webtemplate for web reporting.
Sure points for valid inputs.
Thanks in advance.