-- 
-- Structure de la table `actes_pec` = TABLE1
-- 

CREATE TABLE `actes_pec` (
  `IDPEC` int(100) NOT NULL auto_increment,
  `IDS` int(100) NOT NULL,
  `IDA` int(100) NOT NULL,
  `IDV` int(100) NOT NULL,
  `date` date NOT NULL,
  `heure` varchar(20) collate utf8_unicode_ci NOT NULL,
  `motif` text collate utf8_unicode_ci NOT NULL,
  `diagnostic` varchar(100) collate utf8_unicode_ci NOT NULL,
  `qtt` decimal(10,2) NOT NULL,
  `remise` decimal(10,2) NOT NULL,
  `sortie` varchar(15) collate utf8_unicode_ci NOT NULL default '0',
  KEY `IDPEC` (`IDPEC`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=119 ;


-- 
-- Structure de la table `actes` = TABLE2
-- 

CREATE TABLE `actes` (
  `IDAC` int(255) NOT NULL auto_increment,
  `titleg` varchar(255) collate utf8_unicode_ci NOT NULL,
  `tva` decimal(10,2) NOT NULL,
  `pu` decimal(10,2) NOT NULL,
  `categorie` int(100) NOT NULL,
  KEY `IDAC` (`IDAC`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=133 ;


-- 
-- Structure de la table `actes_users` = TABLE3
-- 

CREATE TABLE `actes_users` (
  `IDAU` int(100) NOT NULL auto_increment,
  `IDPECAU` int(100) NOT NULL,
  `IDACAU` int(100) NOT NULL,
  `IDMAU` int(100) NOT NULL,
  `IDSAU` int(100) NOT NULL default '1',
  `typeAU` varchar(100) collate utf8_unicode_ci NOT NULL,
  `dateAU` date NOT NULL,
  `heureAU` varchar(20) collate utf8_unicode_ci NOT NULL,
  `qttAU` decimal(10,2) NOT NULL,
  `remiseAU` decimal(10,2) NOT NULL,
  `ttcAU` decimal(10,2) NOT NULL,
  KEY `IDAU` (`IDAU`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1522 ;

$Requete = " SELECT T1.*, T2.*, T3.*
             FROM table1 T1, table2 T2, table3 T3
             WHERE T1.cle = T3.cle
             AND T3.cle = 'XX'
             AND T3.cle = 'YY' ";