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_number";
$dbuser1="user1";
$dbuser2="user2";
$dbpass1="password1";
$dbpass2="password2";
$dbname1="database_I";
$dbname2="database_II";
$db1=mssql_connect($dbhost,$dbuser1,$dbpass1);
$db2=mssql_connect($dbhost,$dbuser2,$dbpass2);
mssql_select_db($dbname1,$db1);
mssql_select_db($dbname2,$db2);
$query="SELECT...";
?>