Updatable Union Query

K

Kanga

Hi,

I see I can update a table from the output of a simple select query. However
this doesn't work with a union query.
Is there a way to make a union query updatable?

Thanks,
Kanga
 
A

Allen Browne

No. UNION queries are never updatable.

The best solution is probably going to be to redesign your tables into one,
adding an extra field to indicate whatever difference is intended by having
them in different tables.
 
Top