i have two tables i would like join them so the results are mixed
(SELECT date,headline,profileID,summary,imageURL FROM feed)
UNION
(SELECT date,headline,profileID,summary,imageURL FROM news)
ORDER BY date DESC LIMIT 10;
this works fine - but i would like to now highlight where the article comes so i can color code the results i.e. is it from the feed table or the news table is this possible?
thank G