I am struggling to concatenate fields from two tables , the data was previously being loaded in Excel form now an SQL library is being used. There is different fields but I am looking to extract a few of the fields from both of the tables and concatenate them as they are the same but with different names. Hope that makes sense.
Inner Join (Sales_Log) [Test]: Load [Sales reasons.mins]/60 as Sales, [Sales reasons.areaname] as Area, [Sales reasons.Itemname] as Item
Resident [Sales reasons];
Sales_Log is the Excel file and it contains three fields named Sales, Area and Item and others which I do not need for this new table.
Sales reason a table from an SQL Library I renamed them to match the table from Sales_Log , it also has other fields not needed.
Any help on how to do this , I have view other posts and tried a few other ways with out success. Any help much appreciated.
