Donal
With MySQL, temp_explanations MUST exist before you can INSERT INTO it.
Based on the assumption that temp_explanations is non-existent, you will
have to CREATE TABLE temp_explanations first before running an INSERT
INTO.
Hope that helps.
Inyang
>
>
> Hello,
> I want to do the following qu
Hello,
I want to do the following query
INSERT INTO temp_explanations(tip) SELECT tip FROM explanations WHERE
explanations.file=temp_explanations.file AND
explanations.level=temp_explanations.level;
but I'm getting an 'unknown table temp_explanations' error.
How can I get around this?
Thanks,
