Re: Optimization/Efficiency Question

[techy]

Grygonos,

I'm not sure with access, but with MySQL I would try something like (extremely untested):

    my $updh = $dbh->prepare(q{
       INSERT INTO report_printing_table
       (1,2,3,4,5,6,7,8,9,10,11,12,13)
       SELECT AuditID, Referrals.1, Referrals.2, Referrals.3,
       Referrals.4, Referrals.5,
       Referrals.6, Referrals.7, Referrals.8,
       Referrals.9, Referrals.10, 
       Referrals.11, Referrals.12,
       FROM   Referrals
       INNER JOIN States On (Referrals.10 = States.1)
       WHERE AuditID = ?
    });

    foreach my $audit (keys(%$audits))
    {
        $updh->execute($audit);
    }
    $updh->finish;

Looks like Access does support INSERTing based on SELECT, but thats just based off a quick google, not experience. Also, why are you selecting more columns than you insert? Or is the results of the select also needed somewhere below the snippet that was posted?

Thanks,

techy