OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

queries with tables in two diferent data sources

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Andreas Moroder
Guest





PostPosted: Fri Dec 05, 2003 12:59 pm    Post subject: queries with tables in two diferent data sources Reply with quote

Hello,

in Access I can build queries with table that come from different source
One table may be a dbf one, the other a access one.

Is this possible in openoffice ?

Thanks
Back to top
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Fri Dec 05, 2003 8:44 pm    Post subject: Reply with quote

Not directly, a query is defined within one data source.
However, you can create a temporary snapshot copy of one database within the other and do your query there.
Some dbms tools do provide the means of treating a table in another database as though it were part of the 'local' database (for example Oracle Transparent Gateway) but that is pretty heavy duty stuff.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group