select in two databases (MySQL)

[rwar]

I have a challenge. How can I do a select in two databases?

Details: I have a table pecaspedido (codorder, codclient, codproduct, value) in each database. The table can have the same client in both tables, and of course in both databases, because he (the client) could ordered some products in both systems.

What I want is to put the results (the clients) in a combobox (a html <select></select>), but in some way that the clients appear only one time, and this is what I'm not obtaining.

My code is like below, demonstrating that I'm searching in both systems:

[font=Courier New]<select name="INT_codcomissionado">
  <option value="Todos">Todos os comissionados</option>
<?php
   $QRY_comissionadosintra = mysql_query( "SELECT DISTINCT CodCli
                                           FROM pedidos
                                           WHERE TipoPed IS NULL
                                           AND DataEnvio>='$DAT_datainicio'
                                           AND DataEnvio<='$DAT_datafim'
                                           AND SitPed='Enviado'", $conexao );

   $QRY_comissionadosrastre = mysql_query( "SELECT DISTINCT CodCli
                                            FROM pedidos
                                            WHERE TipoPed IS NULL
                                            AND DataEnvio>='$DAT_datainicio'
                                            AND DataEnvio<='$DAT_datafim'
                                            AND SitPed='Enviado'", $link );

   while( $RES_comissionados = mysql_fetch_array( $QRY_comissionadosintra ))
   {
      $INT_codcomissionado = $RES_comissionados['CodCli'];
      $STR_nomecomissionado = nomecli( $INT_codcomissionado, $conexao );
?>
      <option value="<?php echo $INT_codcomissionado; ?>"><?php echo $STR_nomecomissionado; ?></option>
<?php
   }

   while( $RES_comissionados = mysql_fetch_array( $QRY_comissionadosrastre ))
   {
      $INT_codcomissionado = $RES_comissionados['CodCli'];
      $STR_nomecomissionado = nomecli( $INT_codcomissionado, $conexao );
?>
      <option value="<?php echo $INT_codcomissionado; ?>"><?php echo $STR_nomecomissionado; ?></option>
<?php
   }
?>
</select>

How can I do that? I cannot use DISTINT or INNER JOIN 'cause the data are in two systems.

Thanks for any help.[/font]

[Phil.Roberts]

SELECT column FROM databasename.tablename

[rwar]

Thansk for the answer, Phil.Roberts, but another problem raised: the databases are in different servers...

[Resident Evil]

like

$query = "SELECT omg.table1, omg.table2 FROM table1, table2"; 

iirc

[rwar]

Resident Evil, I have tried putting the code that Phil.Roberts posted here, and then yours. Both codes don't do nothing, because they are in separated servers, each one together with its respective database. Can you understand?

[aQustic]

I think you have to do two separate queries, one to each server, and then manually loop and compare the different results with php.