How to join 2 tables but same data's? : Is it possible to join to tables like in the picture,[example picture][1]

there are no foreign key in svotes but there are the same records. 
In the select option tag I putted the school_year and the option are `2015-2016,2016-2017`. If I click the 2016 it should that the other table svotes can display the year of 2016 can it be possible? and How?


Here's my code:

    <script type="text/javascript">
    				function getyr(str) {
    						if (window.XMLHttpRequest) {
    							xmlhttp=new XMLHttpRequest();
    						} else { // code for IE6, IE5
    						xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
    					}
    					xmlhttp.onreadystatechange=function() {
    				if (xmlhttp.readyState==4 && xmlhttp.status==200) {
    				document.getElementById("result").innerHTML=xmlhttp.responseText;
    			  }
    		   }
    //this part will be handle
    		  xmlhttp.open("GET","get_winner.php?no="+str,true);
            xmlhttp.send();
          }
    	</script>
    	       
    	  <select style="margin-left:-313px;" name="sy_no" onchange="getyr(this.value)">
    				<option></option>
                      <?php
    						include('../connect.php');
                            $sql2 = mysql_query("SELECT * FROM school_year");
    while ($row1=mysql_fetch_array($sql2)){
    	echo "<option value=".$row1['syearid'].">".$row1['from_year'].'-'.$row1['to_year']."</option>";
    					}
    								?>
    						</select>
	get_winner.php

    <?php
    
    include('../connect.php');
     
      $no = $_GET['no'];
    		//this is where I get the year
      	 $stud = mysql_query("SELECT * FROM  studentvotes,school_year WHERE school_year.from_year = studentvotes.year AND studentvotes.year = '$no' ") or die(mysql_error());
      echo"<center>";
      echo "<form action='' method='POST'  enctype='multipart/form-data' >";
     echo "  <table class='table table-striped table-bordered table-hover' id='dataTables-example'>";
        echo "<tr>";
        
          echo "<th>IDno</th>";
         
          echo "<th>Action</th>";
        echo "</tr>";
    			
    		
    		while ($row=mysql_fetch_array($stud)){
    		$result = mysql_query("SELECT * FROM studenvotes,school_year WHERE   studenvotes.year = school_year.from_year") or die(mysql_error());
        $r1 = mysql_fetch_assoc($result);
    	
    	
      ?>
      <tr class="headings">
    	
    						<td><?php echo $row['idno']; ?></td>
    					
    					<td> <a href="editcandidate.php?candid=<?php echo $row['candid']; ?> "style="border:1px solid grey; background:grey; border-radius:10%; padding:5px 14px; color:white; text-decoration:none; "> Edit </a></td>
    				
    			<?php
    		
    					}
    			?>		

		


  [1]: http://i.stack.imgur.com/bg4e8.png