foreach $comp_id (keys %hash){
	
$sql = <<END_SQL;

select comp_name from company where comp_name = '$hash{$comp_id}'

END_SQL

$query = &execsql($sql);

if(!$data[0]){
	print "insert '$hash{$comp_id}' in table COMPANY\n";
}
	
while (@data = $query->fetchrow) {

	if($data[0]){
		print "insert $comp_id in table TYPES for $data[0]\n";
	}
   }
}