Как объединить две выборки?

[Sav2907]

Есть код, как объединить две выборки?

<?php

$result = $connection->query("
SELECT
DISTINCT login, date
FROM `Preproduction`.`rnk_bd`
WHERE date = '2016-11-10'
");

while($row = mysqli_fetch_assoc($result) ) {
  
    $result2 = $connection->query("
    SELECT
    SUM(proc+chs_prost_vids) AS SUM1,
    SUM(chas + chas_prost) AS SUM2
    FROM `Preproduction`.`rnk_bd`
    WHERE login LIKE '$row[login]' AND date = '$row[date]'
    ");

    WHILE($row2 = mysqli_fetch_array($result2)){

        echo $row['login'].'...'.round($row2['SUM1'], 2).'...'.round($row2['SUM2'], 2).'<br/>';

    }

}

?>

 

[WMix]

SELECT
    login, date,
    SUM( proc+chs_prost_vids ) AS SUM1,
    SUM( chas + chas_prost ) AS SUM2
FROM `Preproduction`.`rnk_bd`
WHERE `date` = '2016-11-10'
GROUP BY login

 

[Sav2907]

@WMix, спасибо большое, работает