Right now I have a a query that searches 4 tables based on the primary key. It returns any values associated with that primary key. The primary key is [Metal OS].
This is my query:
SELECT [HMBA B101, 25C].[Metal OS], [HMBA B101, 25C].*, [HMBA B102,25C].*, [HMBA B103, 25C].*, [HMBA B104, 25C].*...