I have used a Union Select Query to combine the data from two tables. Is there anyway of changing the colour of the data in one of the tables so that the user can tell the difference between the different sets of data?
How about adding a column in the query which has the name of the table ie SELECT "Table1" as TableName, etc.... UNION SELECT "Table2" as TableName, etc.