queries with tables in two diferent data sources

[Andreas Moroder]

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

[dfrench]

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.