November 26th, 2003, 03:20 AM
I m using MSDE as a backend for my system, in which i have more then one database created depending upon the date i.e. I have distributed the database year wise. currently i have 5 databse created in MSDE.
I m using VB as a front end tool.
Problem : I have problem while fetching the data from MSDE. Client query is to retrieve certain data which spans more then 1 database. How can i fire a single query to get records from multiple databases? Is it possible for me to have single query to retrive the data or some other option?
November 26th, 2003, 02:31 PM
Yes, I believe you can use a single query to get records from multiple databases. In your FROM clause you must explicitely specify your database like this:
November 26th, 2003, 10:43 PM
Thanx for ur kind suggestion