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   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



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
Fifth Degree Black Belt

Please log in to comment