Select Where Query

[sarsmelt]

I have 2 tables:
Machines
ID Machine
1 AAAAA
2 BBBBB

Product_Code_Data
MM Machine
1A 12
2B 10
These tables have no relationship.

What I want to do is create a select...from...where query that pulls the name of a machine with the MM#
Here is the code I'm using

SELECT Machines.Machine, Machine.ID
FROM Product_Code_Data, Machines
WHERE (((Machines.ID)=[Product_Code_Data].[Machine1]))
UNION ALL
SELECT Machines.Machine, Machine.ID
FROM Product_Code_Data, Machines
WHERE (((Machines.ID)=[Product_Code_Data].[Machine2]));


When I hit the run button it does nothing. It doesn't give a dialog box or an error at all.

I have other select where queries in this database and they work wonderfully.
I'm not sure what I'm doing wrong.

Thanks in advance

[June7]

Why are you 'running' a SELECT query? Why work directly with tables and queries? Should work with forms and reports bound to tables/queries.

This isn't just a SELECT query, it is UNION of SELECT queries. Why don't you use INNER JOIN instead of WHERE? That should be more efficient.

[sarsmelt]

I've actually changed my mind and decided to go with update queries instead of doing it this way as the reason I'm struggling through this is to make it easier to edit in the long run. It will be much simpler with update queries. I can't believe I didn't think if it before :P
Thanks for your input though.