Joining Databases

[Ruslan Zasukhin]

on 7/22/03 3:52, Deane Venske at dean at eduss.com wrote:

Hi Deane,

> I was wondering, is there a way to do cross database queries?

No. Probably will be implemented in 2.x

> I'm just investigating whether we want to put all our data into 1 big DB or
> have smaller DBs. We write a few different programs, they all share some
> common things, like users, so we don't want our customers having to add
> users to each product. I've thought of having a main DB and using a
> replication program to propogate user changes across all DBs, and so have
> duplicates all around. Not my ideal solution, but we will just have to see.

Well, I think you still can use different dbs,
Just you will need do several queries to get results.

E.g. At first you do query to users db, get some cursor, get some values,.
Using that values you build new SQL query to next db...

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------