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

Comments

Please log in to comment

Answers

0

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).

Answered 02/07/2014 by: grayematter
Fourth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity