SQL Query

Hi

help!!!

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?

Thanking u

Bhalchandra

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:

dbname.dbowner.tablename

Thanx for ur kind suggestion

Bhalchandra Mone