Select Code to Download

Router_Name  Serial_No Fru_Desc Location        Status

...
RouterB     HH     FRUH     FPC7 PIC7     Online
RouterB     II     FRUI     FPC8 PIC8     Online
RouterB     JJ     FRUJ     FPC9 PIC9     Online

RouterA     CC     FRUC     FPC1 PIC1     Online
...
RouterB     HH     FRUH     FPC7 PIC7     Online
RouterB     II     FRUI     FPC8 PIC8     Online
RouterB     JJ     FRUJ     FPC10 PIC10     Online

        my $sth_m  = $dbh->prepare("Select Serial_No,Fru_Desc,Status f
+rom master_table2 where Router_Name = ?") or die "Cannot prepare mast
+er_table for selecting rows based on router name:" .$dbh->errstr;

...
    (here i have the code to compare each row from @db_rows to each an
+d every row of @live_rows
    .......
}

First Iteration - Master_table

...
JJ    FRUJ