This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 好长时间没敢问问题了。Now, SQL:: 怎么 join 本地和 remote 的两张表。谢谢。
-aka(棒棒);
2004-11-12
(#1978747@0)
-
try thissame as local join, the only difference is the local db should have dblink link to the remote, and the link user should have select privilege on the remote db, for example, in Oracle:
SELECT A.COL_NAME,B.COL_NAME2...
FROM LOCAL_TAB A, RMOTE_TAB@DBLINK B
WHERE A.COL1=B.COL2;
-changshan(偷偷乐);
2004-11-12
{278}
(#1978880@0)