How do I create a report that has all the assets that i select in it?
When I create a report with the wizard i can only select 1 of the assets in the drop down menu. I would like to create a report that has multiple assets in it. Im not very SQL savvy and I could use a little help
Please log in to answer
Posted by: Hobbsy 4 years ago
Posted by: grayematter 4 years ago
This can be done in SQL, but it is easiest if you create the parts in the wizard and stitch them together later. Note that when you do this, each of the sub queries has to have the same number of columns. Once you have the sub queries, you can UNION them together. More info on the UNION syntax is available here: http://dev.mysql.com/doc/refman/5.7/en/union.html