I'm pretty sure that what you are trying to accomplish can be done I'm just not sure of the exact edit that you would need to make to get it this way. You may want to try adding in your extra where parameters after the others at the end of the query. Customizing this RS code to create a new result is not a supported feature of the Power Store so it is not something that we are able to provide support for. I would suggest taking some time to review the SQL in the query and try to understand what it is doing so that you can customize it to fit your needs. If through trial and error and examination you cannot get the query returning records like you want it might be best to just create your own new query to get the results you are looking for. There are many good resources out there for crafting advanced queries and some tools that can accomplish this for you, a tool that comes to mind is Navicat.
