On Thu, 2002-11-28 at 21:21, yudha wrote: > Dear Milist; > Please give me some advices and help. How can i do > "select" the TABLE_1 on other database DB_2, > but currently i'm connecting to on DB_1. > > ORACLE : > Current_DB_1 #> Select * From DB_2.TABLE_1; > > MS-SQL : > Current_DB_1 #> Select * From DB_2..TABLE_2; > > PostGre : > Current_DB_1 #> How do i write...???
You cannot read from another database. In 7.3, you can have multiple schemas in one database and the syntax for reading a file from another schema is: SELECT * FROM schema.table... I understand that 7.3's release is imminent. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "The earth is the LORD'S, and the fullness thereof; the world, and they that dwell therein." Psalms 24:1
signature.asc
Description: This is a digitally signed message part
