Topic group Related topics

Live joins may be used only if:

All joins are left-to-right outer joins.

All join are equi-joins.

All join conditions are satisfied by indexes.

Output ordering is not defined.

The query contains no elements listed above that would prevent single-table updatability.