The documentation states that the product allows editing joined tables by choosing which table to edit from the drop-down table menu.
However, as soon as I add a join, the grid goes into read only mode, and the table drop-down does not show any table names. This happens even if I don't select any fields from the second table.
- I tried changing paginated mode, and that makes no difference.
- I tried different ways of specifying the join, and that makes no difference.
- It doesn't matter whether I select a single column or all columns.
Code: Select all
SELECT
ai.session_id
FROM
apnea_info ai
Code: Select all
SELECT
ai.session_id
FROM apnea_info ai
JOIN xtra_info xi on ai.id = xi.id
Can anybody help?