Jointure entre deux tables

$query = "DROP TABLE IF EXISTS mailclient";
$resul = mysql_query($query)
	or die ("Requete '$query' invalide");

$query = "CREATE TABLE mailclient (
  num_adh int(5) unsigned NOT NULL auto_increment,
  login varchar(20) NOT NULL default '*',
  password varchar(20) NOT NULL default '*',
  prenom1 varchar(25) NOT NULL default '*',
  nom1 varchar(20) NOT NULL default '*',
  tel varchar(15) NOT NULL default '0',
  mail varchar(45) NOT NULL default '*',
  PRIMARY KEY  (num_adh)
) TYPE=MyISAM";
$result = mysql_query($query)
	or die ("Requete '$query' invalide");
	
$query = "DROP TABLE IF EXISTS mailparain";
$resul = mysql_query($query)
	or die ("Requete '$query' invalide");
	
$query = "CREATE TABLE mailparain (
  num_adh varchar(20) NOT NULL default '*',
  login varchar(20) NOT NULL default '*',
  password varchar(20) NOT NULL default '*',
  prenom1 varchar(25) NOT NULL default '*',
  nom1 varchar(20) NOT NULL default '*',
  tel varchar(15) NOT NULL default '0',
  mail varchar(45) NOT NULL default '*',
  PRIMARY KEY  (num_adh)
) TYPE=MyISAM";
$result = mysql_query($query)
	or die ("Requete '$query' invalide");	
	
$query = "INSERT INTO mailclient 
SELECT num_adh, login, password, prenom1, nom1, tel, mail 
FROM new_client";
$result = mysql_query($query)
	or die("Requête '$query' invalide : ".mysql_error());
	
$query = "INSERT INTO mailparain 
SELECT num_adh, login, password, prenom1, nom1, tel, mail 
FROM adherent";
$result = mysql_query($query)
	or die("Requête '$query' invalide : ".mysql_error());
	
$query = "SELECT mailclient.num_adh, mailclient.login, mailclient.password, mailclient.nom1, mailclient.prenom1, mailclient.tel, mailparrain.num_adh, mailparrain.login, mailparrain.password, mailparrain.nom1, mailparrain.prenom1, mailparrain.telFROM mailclient, mailparain
WHERE mailclient.num_adh = mailparain.num_adh";
$result = mysql_query($query)
	or die ("Requete '$query' invalide"); 

 	if (mysql_num_rows($result) == 0) {
			print"<h3>Aucune donnée dans la base</h3>:<br>";
	}