Question

Locked

Problem editing data in queries

By water_off_a_ducks_back ·
I was wondering if anybody could help me with the following...

I have two queries which are based on three tables - q1 is based on t1 and t3, q2 is based on q2 and q3. Each table has the fields {HID, yr, mo} and then some data fields. Each has {HID, yr, mo} as the primary key.

The two queries are structurally identical, with the following SQL:

SELECT t1.HID, t1.yr, t1.mo, t1.somedata1, ..., ..., t3.somedatax
FROM t1 INNER JOIN t3 ON (t1.mo = t3.mo) AND (t1.yr = t3.yr) AND (t1.HID = t3.HID);

The problem is that I can sometimes only open one of the queries for editing, and the other one is locked, but then sometimes, the other one is editable and the other is not. Would anybody be able to tell me (a) why this might be, and (b) how I can work around it?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums