K1000: I have three asset types cell phones, Mifi's, and tablets I would like to create a report with all of these combined.
All contain the same fields and I am trying to create a report that displays all of them combined. I am not familiar with SQL enough to do this on my own. Any help on how to do this would be appreciated.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
grayematter
10 years ago
Probably the easiest way to do this is to union the queries. Get each query pulling the data from its asset type. Make sure the separate queries have the same number and types of columns. Then connect the queries with a union (http://dev.mysql.com/doc/refman/5.6/en/union.html).
