sql - Optimizing self join on all columns in an ms access table - without any conditions/clauses -

sql - Optimizing self join on all columns in an ms access table - without any conditions/clauses -

i coding in ms access using vba.

i trying self bring together table in ms access . has 8 columns , need cartesian product all.

the problem query have written takes long execute (more 30 mins!) . need help on how optimise it.

the query written follows:

insert table1 select t1.col1, t2.col2, t3.col3, t4.col4, t5.col5, t6.col6,t7.col7,t8.col8 table1 t1, table1 t2, table1 t3, table1 t4, table1 t5, table1 t6, table1 t7, table1 t8;

i checked other threads found none reply query.

thanks in advance!

sql vba ms-access self-join