Selects records not matching compare two tables mysql php


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>


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

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


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

     <?php } ?>