I have a code that selects two columns in a database:
SELECT DISTINCT ('owner_account'), 'grouped_country'
FROM 'genuine_k_value';
What I have to do is insert values into another table. I have tried to do the following:
INSERT INTO 'genuine_agents' ( 'agent_email', 'agent_country' )
SELECT DISTINCT ('owner_account'), 'grouped_country'
FROM 'genuine_k_value';
But it gives me:
Error: Token mismatch
I know that the query has to be in a form:
INSERT INTO tabla (´columna1´, ´columna2´)
VALUES ('valor 1', 'valor 2');
But I can not apply it to my case.