OK solved - the above reply about the INT requirement of the field solved everything and the infor skhanal provided earlier worked a charm. Really hope this helps someone else.

SELECT _2005_master.ID, _2005_Canadian.Area, _2005_Canadian.Zip_Code, _2005_master.upcid, _2005_master.quantity_sold, _2005_master.quantity_used, _2005_master.quantity_used_stock_overage, _2005_master.quantity_used_stock_shortage, _2005_master.quantity_prevoh, _2005_master.quantity_reqin, _2005_master.quantity_onhand, _2005_master.quantity_onhand_full, _2005_master.cost_per_unit, _2005_master.revenue_per_unit, _2005_master.sales_tax, _2005_master.par_amount, _2005_master.order_amount, _2005_master.oztype, _2005_master.stnname, _2005_master.vendname, _2005_master.classname, _2005_master.catname, _2005_master.qualname, _2005_master.brandname, _2005_master.bottle_size, _2005_master.case_size, _2005_master.open_datetime, _2005_master.close_datetime, _2005_master.open_userid, _2005_master.close_userid, _2005_master.oxdate, _2005_master.cxdate, _2005_master.quantity_spill, _2005_master.quantity_comp, _2005_master.quantity_otherwaste, _2005_master.first_close_datetime
FROM _2005_master
INNER JOIN _2005_Canadian ON _2005_master.ID = _2005_Canadian.ID


Works perfect!!!!!!