Results 1 to 8 of 8

Thread: join databases

  1. #1

    join databases

    HI, I would like to ask some DB experts

    I got asked "how to join two database to SQL? "

    I guess its not asking inner join, outjoin thing, right?

  2. #2

    Re: join databases

    Join databases? Or join tables?

    How did you answer the question?
    Joe Strazzere
    Visit my website: AllThingsQuality.com to learn more about quality, testing, and QA!

  3. #3

    Re: join databases

    I said its dblink(), but I can't get into detail, I think its not typically SQL questions, innjoin is about joining 2 TABLES

  4. #4

    Re: join databases

    Never heard before regarding joining database,I feel it might be joining the table.
    DBs tables are normally created,updated etc through SQL.
    He could have meant as how do you create the DB tables with SQL ?

  5. #5
    Advanced Member
    Join Date
    Aug 2001
    Minneapolis, MN

    Re: join databases

    There are database links that can be implemented in Oracle such that you can query across multiple databases.

    And, depending on how one defines a database, in MySQL you can query across multiple databases assuming that they're on the same server in the same database file and you have permissions on the target databases.

    Lastly, if you're trying to bridge, for example, a DB2 database and an Oracle database, you could use MS Access. Or, if you're looking for something non-Microsoft, you could look at Quest's Toad for Data Analysis. I've never used this tool, so I'm not sure how well it would or would not work for you.

    All in all, it depends on the situation in front of you and how creative you can or want to be.
    Jason Trebilcock

    "The single biggest problem in communication is the illusion that it has taken place."

    -George Bernard Shaw, Irish playwright and Nobel Prize winner, 1856-1950

  6. #6

    Re: join databases

    And by the way, radhe, inner join and outer join both apply to joining tables, not databases (whatever the latter means).

  7. #7

    Re: join databases

    radhe94539, in this case I would try to get more details from interviewer about this question

  8. #8

    Re: join databases

    I think joining "two database to sql" means joining two tables from two different databases.For this you have to put database name in front of table name.The query in the following link is will help. Its the link to devx forum: http://forums.devx.com/showthread.php?t=17882



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 05:58 PM.

Copyright BetaSoft Inc.