I have 2 databases (with different user names and different
passwords), and I need to join column_1 from table_A (on first
database: database_I) on column_2 from table_B (on second database:
database_II).
How query should likes? I want to do this in php - where should I
specify different user names and diffrent passwords for databases?
<?php
$dbhost="server _name\instance_ name,port_numbe r";
$dbuser1="user1 ";
$dbuser2="user2 ";
$dbpass1="passw ord1";
$dbpass2="passw ord2";
$dbname1="datab ase_I";
$dbname2="datab ase_II";
$db1=mssql_conn ect($dbhost,$db user1,$dbpass1) ;
$db2=mssql_conn ect($dbhost,$db user2,$dbpass2) ;
mssql_select_db ($dbname1,$db1) ;
mssql_select_db ($dbname2,$db2) ;
$query="SELECT. ..";
?>