$search = mysql_query("SELECT *
FROM `albums`
INNER JOIN `artists`
ON `albums`.`aArtist` = `artists`.`aId`
WHERE `albums`.`aName` LIKE '%$s%' or `artists`.`aName` LIKE '%$s%'") or die("error:" . mysql_error());
while($searchr=mysql_fetch_array($search)){
$logo = $searchr['aLogo'];
и т.д, `albums`.`aName` as `albumsName`SELECT `albums`.* FROM ...
Сложный
Средний