Is there a way to edit a result set coming from a custom query?

Answered

So I do a 'single' SQL query like select * from table a, table b where a.id = b.extid. When I try to edit the result I get "table is read-only. unresolved table reference'. 

I understand the limitation is probably because I'm running a custom SQL but I'm wondering if there is a way to workaround this and make it editable? I tried adding PK and FKs to the resultset but with no luck.

Please sign in to leave a comment.