SELECT `'Warehouse Bins Granby Jan 12$'`.ITEM_PACK, `'Warehouse Bins Granby Jan 12$'`.`LOT NUMBER`, `'Warehouse Bins Granby Jan 12$'`.`INVENTORY VALUE AVANT` AS INVENTORY, `'Warehouse Bins Granby Jan 12$'`.`QTY AVAIL AVANT` AS QTY, 'Jan' as MONTH
FROM `T:\TEMP\AVANT INVENTAIRE.xlsx`.`'Warehouse Bins Granby Jan 12$'` `'Warehouse Bins Granby Jan 12$'`
union all
SELECT `'Warehouse Bins Granby Sept 12$'`.ITEM_PACK, `'Warehouse Bins Granby Sept 12$'`.`LOT NUMBER`, `'Warehouse Bins Granby Sept 12$'`.`INVENTORY VALUE APRES`, `'Warehouse Bins Granby Sept 12$'`.`QTY AVAIL APRES`, 'Sept' AS MONTH
FROM `T:\TEMP\APRES INVENTAIRE.xlsx`.`'Warehouse Bins Granby Sept 12$'` `'Warehouse Bins Granby Sept 12$'`