Vælge fra 2 tabeller

Jeg har et problem, når jeg skal vælge fra 2 tabeller i en WHERE funktion, udskriver alle posterne i tabellen hvor kriterierne er opfyldt, men den udskriver alle poster det antal gange der er opfyldte kritierier... fx.....

jeg har 5 kunder som har købt 3 ting ialt.... så udskriver den alle kunderne, og den udskriver alle kunderne 3 gange... hvorfor.. her er min kode(undskyld den kodede kode)::::::

<HTML>
<HEAD>
<meta http-equiv="Content-Language" content="da">

<TITLE>Salg for idag</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">



</HEAD><br><center>

<?
include("../includes/database.php");

$dato = date("Y-m-d");

$connection = mysql_connect("$host", "$user", "$pass");
  mysql_select_db("$database", $connection);
 
echo "<input type=button value='Udskriv dagens salg' onclick='self.print()'><br><table border='1' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='100%' id='AutoNumber1' height='20'>
  <tr>
    <td width='100%' colspan='8' height='46'><b><font face='Verdana'>Fit 'n Fun
    - Oversigt over salg fra d. </font></b><i> $dato</td>
  </tr><tr>
    <td width='12%' height='40' align='center'>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'><b>Fornavn:</b></font></td>
    <td width='12%' height='40' align='center'>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'><B>Efternavn:</b></font></td>
    <td width='12%' height='40' align='center'><b>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'>Adresse:</font></b></td>
    <td width='12%' height='40' align='center'><b>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'>Postnr.:</font></b></td>
    <td width='12%' height='40' align='center'><b>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'>Telefonnr.:</font></b></td>
    <td width='13%' height='40' align='center'><b>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'>Cpr.:</font></b></td>
    <td width='13%' height='40' align='center'><b>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'>Kontingent type:</font></b></td>
    <td width='13%' height='40' align='center'><b>
    <font face='Verdana' style='font-size: 11pt; font-weight: 20'>Salgspris:</font></b></td>
  </tr>";
  $result2 = mysql_query("SELECT Medlemmer.*, Medlemskaber.*  FROM Medlemskaber, Medlemmer WHERE Medlemskaber.Salgsdato = '$dato' ORDER BY Fornavn ")  or die(mysql_error());
 
  while($row = mysql_fetch_assoc($result2)) {



echo "


 
  <tr>
    <td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Fornavn]</td>
<td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Efternavn]</td>
<td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Adresse]</td>
<td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><center><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Postnummer]</td>
<td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><center><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Telefon]</td>
<td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><center><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Cpr]</td>
<td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><center><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Vare_ID]</td>
<td bordercolor='#FFFFFF' bordercolorlight='#FFFFFF' bordercolordark='#FFFFFF' width='12%' height='20' valign='center'><center><font face='Verdana' style='font-size: 8pt; font-weight: 20'>$row[Salgspris]</td>



";

}
echo "  </tr>
</table>";
?>
</BODY>
</HTML>