Query completion

[Sophie DB44]

Hi,

I'm creating a new table using the following query:
create table new_table(unique (ID)) as (select table1.ID as ID,table2.VALUE as VALUE from table1,table2 where table1.PARAM=table2.PARAM);

It is worth noting that table1.ID and table2.PARAM are UNIQUE.

table1 has about 12 millions rows and table2 has about 6 millions rows.

The query is lasting and I wanted to have an idea about its completion.

So I looked at the "Number of rows inserted" from "SHOW ENGINE INNODB STATUS" but I got a value that is over 12 millions...

What did I do wrong ? Any idea someone ?

Thx !