Select from Multiple Pervasive Databses

[uff555]

I have two databases for two different companies. I would like to look at sales including both companies. Is is possible to select fields from two different databases in one view?

 

[ettienne]

No.
You will have to combine the data in a temporary database and then query that, or use a tool like Insight that will do it for you.

 

[uff555]

How can I combine Data in a temp database? Copy the .DAT files?

 

[ettienne]

Um, no that will not work.
How good are your programming and db skills?

 

[Jay Converse]

It's called a Union query.

 

[uff555]

I am proficient in programming and some DB stuff. I was trying to write a query to make a union of two tables. But pervasive proved unable to query a second database.

 

[Jay Converse]

Use MSAccess.

 

[DougHennig]

Stonefield Query (

http://www.stonefieldquery.com)

can query on multiple databases at the same time.

Doug