SQL to export query into table

[mario]

Is there an SQL code or command in MS Access that allows me to export query
results into an table. I'm not worried about the redundancy part as it's a
small table. The problem is, I am not able to update a table using data from
a querry that has joins with other table.

Thanks

 

[John W. Vinson]

Is there an SQL code or command in MS Access that allows me to export query
results into an table. I'm not worried about the redundancy part as it's a
small table. The problem is, I am not able to update a table using data from
a querry that has joins with other table.

Thanks

Sure; an Append query:

INSERT INTO targettable(field, field, field)
SELECT field, field, field FROM <wherever>

By using appropreate joins and indexes you can prevent adding duplicates.

Update queries involving joins CAN work - not all queries are updateable, but
most are. What specific query is failing to update for you? Could you post the
SQL view? It may be fixable.