I have three tables, the jos_users, table_a, and table_b. Tables a and b have columns that are called 'user_id' and are user ids. Neither 'user_id' columns in tables a and b are primary keys.
I created a join that left joined jos_users 'id'with table_a, 'user_id'
and a second left join with jos_users 'id'to table_b ,'user_id.
I cannot edit the 'user_id' in table b. I can change the value and save it, but it doesn't save. Is this to be expected, or have I constructed the joined table incorrectly?
I created a join that left joined jos_users 'id'with table_a, 'user_id'
and a second left join with jos_users 'id'to table_b ,'user_id.
I cannot edit the 'user_id' in table b. I can change the value and save it, but it doesn't save. Is this to be expected, or have I constructed the joined table incorrectly?