I have a selection of the following, but it repeats the results of the second inner selection 3 times. Can anyone tell me why this is Besides, when I get results, how will I know when the result comes from a table? Home_content or facilities_table Choose from select (from hm_id, hm_name, hm_summary, match (hm_name, hm_summary) ('test') as a score from home_content where match (hm_name, hm_summary) Against the score (fac_title, fac_summary) ('test')) against the UNION selection fac_id, fac_name, fac_summary, match (fac_title, fac_summary) match (as opposed to 'test_') (score from facilities_table) DESC Thank you in advance can not see it Why are you getting duplicates? Query: There are no duplicates in the source table The same data appears in home_content and facilties_table The second part of the question reads easily to decide which table comes from the union's content, that by adding a continuous column for every question of uni...