MS Access Delete Query with Left Join -


i trying run delete query records in table 'csd' not available in table 'client codes dealing'. getting error 'could not delete specified tables'

delete csd.* csd left join [client codes dealing] on csd.client = [client codes     dealing].clientcode ((([client codes dealing].clientcode) null)); 

in comment mentioned [client codes dealing] union query. anytime union query involved, entire query made read-only (see why query read-only?).

the simplest thing turn union query make-table query, replace name of union query name of temporary local table created make-table query.


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -