Hi I have 2 mysql tables - (no relations defined )
One table action_def has a column called tasks.
Another table transactions has a column called task.
I would like to add all the distinct tasks in table transactions to the tasks in action_def.
I tried an insert statement (below) to no avail as subquery returns more than one row.
I include code as it may help explain what I am trying to do although it is clearly incorrect.
INSERT INTO action_def (task)
VALUES ((SELECT DISTINCT