Thread: SQL Query

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Bangalore - India
    Posts
    4
    Rep Power
    0

    Question 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
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    6
    Rep Power
    0
    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
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Bangalore - India
    Posts
    4
    Rep Power
    0

    Thanx


    Thanx for ur kind suggestion

    Bhalchandra Mone

IMN logo majestic logo threadwatch logo seochat tools logo