create views

Can you create a view in one database that looks at a table(s) in another database? Thanks. - Jane ------------------------------------------------- Jane Vohden Database Administrator Fairbanks North Star Borough --------------------------------------------------

Jane Vohden wrote in message <957n9s$lhn$1@news.xmission.com>... > >Can you create a view in one database that looks at a table(s) in another >database? Can't see why not. What does the SQL manual say in the CREATE VIEW pages?

Jane Vohden wrote: > > Can you create a view in one database that looks at a table(s) in another > database? > Thanks. - Jane > > ------------------------------------------------- > Jane Vohden > Database Administrator > Fairbanks North Star Borough > -------------------------------------------------- Yes. See (other) Brett's post for syntax. The two databases will need to have the same logging mode. Brett Randall

Jane Vohden ha scritto nel messaggio <957n9s$lhn$1@news.xmission.com>... > >Can you create a view in one database that looks at a table(s) in another >database? >Thanks. - Jane > >------------------------------------------------- >Jane Vohden >Database Administrator >Fairbanks North Star Borough >-------------------------------------------------- > 1) the two databases must have same logging mode 2) in IDS 9.21 (IDS2000) involved tables must NOT have BLOB columns; if they have, yuou would get the error "not implemented yet" in response (IDS 9.21 does not allow remote access to tables with BLOB columns) flavio gattari