Oops,
I listed the wrong query.
Here is the one that sorta works.
select RIGHT(S.barcode, 6), S.description, (select location from last_count where RIGHT(barcode,6) = RIGHT(S.barcode,6)) Location, (select stock from last_count where RIGHT(barcode,6) = RIGHT(S.barcode,6)) Count from slow s ;