grazie x la risposta ma o ho sbagliato o c'è qualcosa che non torna:
io ho provato entrambi i modi, così

$result = mysql_query("SELECT yp_business.name AS name FROM yp_business,yp_infopage WHERE yp_business.infopageid = yp_infopage.infopageid AND yp_infopage.pagetext LIKE '%query%'",$db);
while ($row = mysql_fetch_array($result)) {
echo $row['name'];



$result = sql_query("select busid, name from yp_business where name LIKE '%$query%' order by busid DESC", $dbi);
$row2 = sql_query("select pagetext from yp_infopage where infopageid='$row2[busid]'", $dbi);
echo $row2['name'];

per essere più chiari ecco i campi delle tabelle
yp_businness
name
busid
infopageid

yp_infopage
infopageid
pagetext

GRAZIE