I have two table join and select some columns. I go up to the icon "Change the statement type" the option for Insert, update delete are all grey out. Can only pick Select. I wants to use the Insert or Update option.
I have only one table in the diagram, then the Select, Insert, Update and Delete are all enable.
Toad for Data Analysts Query Builder feature is working as designed. If you select an INSERT, UPDATE, or DELETE statement after adding a single table or view to the Query Builder, you cannot add another table or view because it can only apply to a single table or view. Also, if you add more than one table or view to the Query Builder, this action is disabled because it only applies to a SELECT or CREATE statement.
,
