Сложный запрос SELECT с объеденением трех таблиц

<?
print "<h1>Ваши заявки</h1>";
$link = mysqli_connect("localhost", "??????????", "???????????", "itservice");
$query = "select * from table_bids where bid_declarer_user_id='".$userdata['user_id']."'";
$bids = mysqli_query($link, $query);
 
print "<table border = '1' cellspacing='0'>\n";
//получить названия полей
print "<tr>\n";
while ($field = mysqli_fetch_field($bids))
{
    print "<th>$field->name</th>\n";
}
print "</tr>\n\n";
while ($row = mysqli_fetch_row($bids))
{
    print "<tr>\n";
    foreach ($row as $col=>$val)
    {
        //print "$col";
        if ($col == "1")
        {
            $query = "select concat(user_name, ' ', user_family) as Владелец from table_users where user_id='".$val."'";
            $declarer = mysqli_query($link, $query);
            $row = mysqli_fetch_row($declarer);
            foreach ($row as $col=>$val) print "<td>$val</td>\n";
            mysqli_free_result($declarer);
        }
        elseif ($col == "2")
        {
            if ($val == "0") print "<td>Отсутствует</td>\n";
            else
            {
                $query = "select concat(user_name, ' ', user_family) as Исполнитель from table_users where user_id='".$val."'";
                $performer = mysqli_query($link, $query);
                $row = mysqli_fetch_row($performer);
                foreach ($row as $col=>$val) print "<td>$val</td>\n";
                mysqli_free_result($performer);
            }
        }
        elseif ($col == "3")
        {
            $query = "select concat(device_type, ' ', device_firm, ' ', device_model) as Объект from table_devices where device_id='".$val."'";
            $device = mysqli_query($link, $query);
            $row = mysqli_fetch_row($device);
            foreach ($row as $col=>$val) print "<td>$val</td>\n";
            mysqli_free_result($device);
        }
        else print "<td>$val</td>\n";
    }
}
print "</tr>\n\n";
print "</table>\n";
// очищаем результирующий набор
mysqli_free_result($bids);
?>