SQL In 2 Databases

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Group

I was wondering how i could get my simple SQL query to check through 2
databases?
Both databases are in c:\data\
Called maindata.mdb & backdata.mdb
both need to be search in table2

My SQL is currently just "Select * From Table2"

Any ideas?

Thanks!




.

Relevant Pages

  • Re: SQL In 2 Databases
    ... >I was wondering how i could get my simple SQL query to check through 2 ... In maindata define a new View / Query which joins the real Table2 ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL HELP WITH LAST TIME ONLY
    ... >I have got a SQL query that get information from different databases, ... SELECT TOP 1 Number, Durations, ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Re: Querying ODBC Tables
    ... databases of the same structure. ... have a table called customer. ... I want a SQL query that pulls back 21 records in total from ... the dataset containing the cross join of customer table and order ...
    (microsoft.public.access.queries)
  • Using SQL format function in Access 2003
    ... We've just converted our Access 2000 databases to Access 2003. ... SQL query: ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: A Question on query efficiency
    ... In RDBMS we have references; links is a concept from older network ... databases. ... 2nd related Item in table2 << ...
    (comp.databases.ms-sqlserver)