Vyhledávání ve více tabulkách v databázi pomocí PHP a sql

echo $i_nazev." - ".$xxnazev." - ".$xxzanr." - ".$xxnick." - ".$xxdatum;

$sql = 'SELECT nazev FROM `cd_dvd` WHERE `nazev` LIKE \'%'.$nazev_albumu.'%\'
UNION
SELECT nazev FROM `skupiny` WHERE `nazev` LIKE \'%'.$nazev_skupiny.'%\' 
UNION
SELECT nazev FROM `pisnicky` WHERE `nazev` LIKE \'%'.$nazev_pisne.'%\' 
UNION
SELECT nazev FROM `skupiny` WHERE `zanr` LIKE \'%'.$styl.'%\' 
'; 
$vysledek=mysql_query($sql) or die(mysql_error());
while($zaz = mysql_fetch_object($vysledek)){
$i_id = $zaz->id;
$i_nazev = $zaz->nazev;
$i_seonazev = $zaz->seonazev;
$i_cd_dvd = $zaz->cd_dvd;
$i_kod = $zaz->kod;
$i_id_skupiny = $zaz->id_skupiny;
$i_datum = $zaz->datum;
$i_cena = $zaz->cena;
$i_dph = $zaz->dph;
$i_dostupnych_kusu = $zaz->dostupnych_kusu;
$i_mena = $zaz->mena;
$i_download_kod = $zaz->download_kod;


$vyslemmdek = mysql_query("select * from skupiny where id='$i_id_skupiny' LIMIT 1");
while($zaz = mysql_fetch_object($vyslemmdek)){
$xxid = $zaz->id;
$xxnazev = $zaz->nazev;
$xxseonazev = $zaz->seonazev;
$xxpopis = $zaz->popis;
$xxemail = $zaz->email;
$xxtelefon = $zaz->telefon;
$xxzanr = $zaz->zanr;
$xxsestava = $zaz->sestava;
$xxmistopusobeni = $zaz->mistopusobeni;
$xxurl = $zaz->url;
$xxnick = $zaz->nick;
$xxip = $zaz->ip;
$xxdatum = $zaz->datum;

echo $i_nazev." - ".$xxnazev." - ".$xxzanr." - ".$xxnick." - ".$xxdatum;

}
}