editable join / queries

[Kenny Holmes]

sorry for the newbie question. It has been a few years since I have done anything with mysql and I had limited experience then.

I am converting a MS Access database to mysql. In the query below the result would be editable and allow modifications to the underlying tables directly within the query result. This does not work in mysql.

SELECT
*
FROM
t1
JOIN
t2 ON t1.idt1 = t2.idt1

The same result is ready only for mysql. I know the reason has something to do with making sure each record is explicitly addressed. But why does this work in access and not mysql? Is there a way to mimic the way Access allows the query to be edited?