Selects records not matching compare two tables mysql php

Description

mysql PHP compare two tables to find not matched records. mysql compare match two columns from different tables get records

Find records matching in two tables A and table B get compare columns 

 

MySQL Compare Two Tables to Find Unmatched  columns Records  

 

Compare two tables and match columns find only matching Records data 

 

selects records not matching columns Records compare two tables mysql php

 

   <select class="form-control" id="manageselect" name="manageselect" >

    <option value="">  Select Batch </option>

   <?php

  $showst=mysql_query("SELECT * FROM batchlistshowtime WHERE id NOT IN (SELECT managebatchid FROM managebatchtimeadd)"); 

  // $showst=mysql_query("Select * from batchlistshowtime ORDER BY id DESC"); 

     while($rowlinkst=mysql_fetch_array($showst)){?>  

     <option value="<?php echo $rowlinkst['id']; ?>,<?php echo $rowlinkst['batchname']; ?>"><?php echo $rowlinkst['batchname']; ?></option>

     <?php } ?>

 </select>