I have two tables that I would like to take some of the data from and combine into a third table. I have started to write a union query however I think that SQL does not like spaces in field names. Here is my SQL SELECT
Claimant Name as [Claimant Name] FROM tbl_AIG UNION SELECT Name as [Claimant Name] FROM tbl_Liberty; It is not selecting the first part "Claimant Name". Is this...