Joining Databases

[Deane Venske]

Hi Ruslan,

Thanks for this, I'll probably stick to separate DBs and use multiple
queries. Can you do a query like this :
SELECT * FROM studentClass WHERE studentID IN (1,2,3,4,5)?
So in other words it would return all records from `studentClass` where the
`studentID` value is 1, 2, 3, 4 or 5.

Thanks
Deane

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: Tuesday, July 22, 2003 7:15 PM
To: valentina at lists.macserve.net
Subject: Re: Joining Databases


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
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina