Help to solve ODBC problem

[brenda]

DB Table Field

---

gpehk1con pt_mstr pt_part , pt_desc
gpehk2con pod_det pod_part

Below statement can connect gpehk2con database:
$conn1_id=odbc_connect("gpehk2con","sysprogress","s", SQL_CUR_USE_ODBC);
$sql1 = "select pod_part from PUB.pod_det" ;
if ($result1 = odbc_do($conn1_id, $sql1))
{ odbc_result_all($result1, "BGCOLOR='#AAFFAA' border=3 width=30% bordercolordark = '#FF0000'");
odbc_free_result($result1);
}

I want to link the pt_mstr and pod_det together so as to get the pt_desc (item description).
The select statement is
"select pod_part, pt_desc from pod_det, pt_mstr where pod_part = pt_part".
How to execute the command which involves two databases?? Please advice.

Thanks.

[brenda]

If not this case, do anyone know how to retrieve data from two database in one sql????

[bad76]

😕
By PHP statement directly i think this not possible.

But you use odbc, then look at instruction of db you use
and make a stored proc.

For example the latest DB2 has procedure to join table from different db. Make the rigth query in DB2 environment and materialyze it. Then from PHP access to materialyzed query.

May be this work...

Else you can retrieve data from first table and filter the second for each value of first. For most selective join it's usefull...