multidatabase select in Oracle9i

[enterume]

Hi,

How can i select from multiple database?

I have a code below for MySQL:

SELECT lgn_userid, lgn_parentid,anotherDB.username FROM loginlog, anotherDB.users AS thatDB WHERE thatDB.id=lgn_userid ORDER BY lgn_created desc;

How about Oracle?

[enterume]

any help??

[m-dance]

You or your DBA should create database link to another DB.
Smth. like

CREATE DATABASE LINK db_link2 USING '[e-mail]'