I have quite a big query that needs to update a single table. The data is taken from about 10 different tables. I have the following problem. insert works. Update doesn't always. Any common problem which could cause this?