I did try INNER JOIN before but screwed it up. Need to work on DB sites more than once every year or more so I retain this stuff. And thanks for your explanation, it's helped make sense of it.
So I am returning only the correct results now and not every instance thanks to the INNER JOIN. But I am having issues getting only the thumbnail row to display. Below is the code that displays the image. The first set is unaltered, the second is what I thought you meant to happen. Obviously it's wrong but I don't know the correct answer. Sorry for being dense and thanks in advance!
Oh, and the data in the Thumbnail column is 1 and 0.
-----------------------------
<div class="WADAResultThumbArea"><a href="figure_lines_Detail.php?Line_Id=<?php echo(rawurlencode($row_WADAfigure_lines['Line_Id'])); ?>" title="<?php echo $row_WADAfigure_lines["Line_Name"]; ?>"><img class="WADAResultThumb" border="0" src="images/TESTIMAGES/<?php echo $row_WADAfigure_lines['Filename']; ?>" /></a></div>
-----------------------------
-----------------------------
<div class="WADAResultThumbArea"><?php if($row_WADAfigure_lines['Thumbnail'] = '1') {?>show images<a href="figure_lines_Detail.php?Line_Id=<?php echo(rawurlencode($row_WADAfigure_lines['Line_Id'])); ?>" title="<?php echo $row_WADAfigure_lines["Line_Name"]; ?>"><img class="WADAResultThumb" border="0" src="images/TESTIMAGES/<?php echo $row_WADAfigure_lines['Filename']; ?>" /></a><?php } ?></div>
-----------------------------