use DBI;
...
$self->connectdb(connection => "./db/nr1.db");
$self->createtable(table => $joinTable,
form => $form1);
my $insert = "insert into GITAXNR(gi,ID,quest) select GITAX.gi, GITAX.ID, NRP.quest from GITAX inner join NRP on GITAX.gi = NRP.gi";
$self->do_it(argument => $insert);
####
for(my $j = 1; $j<=4; $j++){
unless($j == 1){
my $database = "attach database './db/nr$j.db' as nrdb$j";
$self->do_it(argument => $database);
my $insert = "insert into GITAXNR(gi,ID,quest) select GITAX.gi, GITAX.ID, NRP.quest from GITAX inner join nr$j.NRP on GITAX.gi = NRP.gi";
$self->do_it(argument => $insert);
}
}
####
insert into GITAXNR(gi,ID,quest) select GITAX.gi, GITAX.ID, NRP.quest from nr1.GITAX inner join nr2.NRP on GITAX.gi = NRP.gi