Haynesey
05-14-2002, 02:12 AM
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?
|
View Full Version : Union Select Query Haynesey 05-14-2002, 02:12 AM 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? Harry 05-14-2002, 02:34 AM 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. HTH |