Two Query's / Need only Matching Records

[larper]

I have two querys that have only 1 field that has same records. I've tried to join on this, but when I run the query I get a message saing "this recordset is not updateable". and Query just freezes. Any Ideas. Thanks!

 

[Joe4]

Are you trying to run some sort of action query (i.e. Append, Delete, Update query)? Certain types of queries are non-updateable, so you cannot change/add/delete values in these types of queries.

In order to determine what is going on, we would need more information on what each query does.

 

[kevinnichols78]

I'm not sure if this is what you are after or not.

table1 contains these fields: Name, 1, 2, 3, 4
Table2 contains these fields: Name, blah,blah1,blah2,blah3

I select all records where table1.name = table2.name with this:

SELECT Table1.*, Table2.*
FROM Table1, Table2
WHERE Table1.Name = Table2.Name;


Kevin