SELECT ManId, ManName, WomanId FROM bd1.Man;

SELECT t1.ManName, bd2.WomanName

FROM     ( SELECT 'Петя' ManName, 111 WomanId

           UNION ALL

           SELECT 'Коля', 112

           UNION ALL

           SELECT 'Вася', 113

          ) AS t1

LEFT JOIN bd2.Woman ON t1.WomanId = bd2.WomanId;

    

    $result1 = mysqli_query($server1, 'SELECT ManId, ManName, WomanId FROM bd1.Man;');

    $result2 = mysqli_query($server2, 'SELECT WomanId, WomanName FROM bd2.Woman;');

    for ($res1 = array(); $tmp = $result1->fetch_array(MYSQLI_ASSOC);) $res1[] = $tmp;

    for ($res2 = array(); $tmp = $result2->fetch_array(MYSQLI_ASSOC);) $res2[] = $tmp;

    foreach($res1 as $man){

      foreach($res2 as $woman){

        if ($man['WomanId'] == $woman['WomanId']) {

          echo $man['ManName']." ".$woman['WomanName']."</br>";

          break;

        }

      }

    }

    $result1 = mysqli_query($server1, 'SELECT ManId, ManName, WomanId FROM bd1.Man;');

    $result2 = mysqli_query($server2, 'SELECT WomanId, WomanName FROM bd2.Woman;');

    $womans = array();

    while ($row2 = mysqli_fetch_array($result2)) { $womans[$row2['WomanId']] = $row2['WomanName']; }

    while ($row1 = mysqli_fetch_array($result1)) {

      echo $row1['ManName']." ".$womans[$row1['WomanId']]."</br>";  

        }

$qer.=('<row id = "'.$id_one[$row[0]].'">'.$id_two[$row[0]].'</row>');

DECLARE xml TEXT;

SET xml='<rows>".$qer."</rows>';

SELECT Art.SortKey, t1.PRICE, t2.VALUE FROM

(select b.value('@id' , 'int') [SortKey], b.value('.' , 'varchar(50)') [ArtNo] FROM @xml.nodes('/rows/row') a(b) )as Art LEFT JOIN

b_catalog_price AS t1 ON t1.PRODUCT_ID = Art.ArtNo LEFT JOIN

b_iblock_element_property AS t2 ON t2.IBLOCK_ELEMENT_ID = t1.PRODUCT_ID AND t2.IBLOCK_PROPERTY_ID = 47

SELECT ManId, ManName, WomanId

FROM bd1.Man;

SELECT WomanId, WomanName

FROM bd2.Woman

WHERE WomanId IN (WomanId-1, WomanId-2, ... , WomanId-N);

$result1 = mysqli_query($server1, 'SELECT ManId, ManName, WomanId FROM bd1.Man;');

while ($row1 = mysqli_fetch_array($result1)) {

    $result2 = mysqli_query($server2, 'SELECT WomanName FROM bd2.Woman WHERE WomanId ='.$row1[2].';');

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

        echo $row1[1]." ".$row2[0]."</br>";  

    }

}