I run the following SQL Query on a MySQL platform.

Table A is a table which has a single column (primary key) and 25K rows. 
Table B has several columns and 75K rows.

It takes 20 minutes to execute following query. I will be glad if you could help.

```
INSERT INTO sometable
SELECT A.PrimaryKeyColumn as keyword, 'SomeText', B.*
FROM A, B
WHERE B.PrimaryKeyColumn = CONCAT(A.PrimaryKeyColumn, B.NotUniqueButIndexedColumn);

```