(SELECT colls, 1 as `tab` FROM table WHERE ...) UNION (SELECT colls, 2 as `tab` FROM table WHERE ...)

<form name="search" action="search.php" method="post">
<div style="width:320px; float:left">
<input style="width:170px; 	margin-right:32px;" placeholder="Введите улицу" type="text" name="query" autofocus="autofocus" required="required" lang="ru" autocomplete="off" id="search11" />
<input style="width:37px; margin-right:23px;" placeholder="Дом" type="text" name="dom" maxlength="5" autocomplete="off" lang="ru" />
<input style="width:30px; margin-right:0px; padding-right:0px;" placeholder="Корп." type="text" name="korp" maxlength="3" autocomplete="off" lang="ru"/>    
</div>
<div style="width:98px; margin-left:320px; padding-top:18px;">
<input style="margin-top:0px;" type="submit" class="subm" value=""/>
</div>
</form>

$query = "(SELECT dom FROM  `table` WHERE  `adress` LIKE  '%$query%' AND 'dom' LIKE '%$dom%')  UNION ALL (SELECT dom FROM  `table2` WHERE  `adress` LIKE  '%$query%') UNION ALL (SELECT adress FROM  `table2` WHERE  `adress` LIKE  '%$query%') ";
$result = mysql_query($query) or die("Запрос ошибочный");
/* Печать результатов в HTML */
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
print "\t<tr>\n";
for ($i=0;$i<=3;$i++) { print "\t\t<td>$line[$i]</td>\n"; }
print "\t</tr>\n";
}
print "</table>\n";

$provider = mysql_fetch_array($res);
include($provider['link']);

$result = mysql_query($query) or die(mysql_error());

Еще я заметил, что хоть у меня и стоит LIKE, но он все равно находит совпадения, даже если ввести букву, которая есть в таблице...

$query = "
(SELECT url FROM `table` WHERE ((adress LIKE '$adress' AND dom LIKE '$dom') OR (adress LIKE '$adress' AND dom LIKE '$dom' AND korp LIKE '$korp' )) LIMIT 1)
UNION ALL 
(SELECT url FROM `table` WHERE ((adress LIKE '$adress' AND dom LIKE '$dom') OR (adress LIKE '$adress' AND dom LIKE '$dom' AND korp LIKE '$korp' )) LIMIT 1)
";
$result = mysql_query($query) or die(mysql_error());
/* Печать результатов в HTML */
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
print "\t<tr>\n";
for ($i=0;$i<=3;$i++) { print "\t\t<td>$line[$i]</td>\n"; }
print "\t</tr>\n";
}
print "</table>\n";

$provider = mysql_fetch_array($result);
include($provider['link']);

include($provider['url']);

while ($line = mysql_fetch_array($result, MYSQL_NUM))

print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
print "\t<tr>\n";
for ($i=0;$i<=3;$i++) { print "\t\t<td>$line[$i]</td>\n"; }
print "\t</tr>\n";
}
print "</table>\n";