Two Database

[sislman]

Hi,

I have two databases.

DB1 - Is main repository of data
DB2 - Contains highlevel data i.e. Scheme Name, Inception Date (1 line of data for each of our Travel schemes)

I would like to write a query that will enable me to do the following: -

1) List only lines of data from DB1 that match with the Scheme Name I specify in the query.
2) Where that Scheme Name matches the Scheme Name in DB2 show the Inception Date from DB2 against each line of date shown in the query result.

Thanks for your help.

Matt

 

[Rabbie]

Why do you have 2 databases? Why not merge them and then you can extract what you want with a query.

Alternatively set up a linked table so you can see all the data from 1 DB

You query should be like

SELECT db1table.shchemename,db2table.inceptiondate FROM db2table INNER JOIN db2table ON db2table.shemename=db1table.schemename

HTH

Rob

 

[sislman]

Hi,

DB1 is received from our Agents and contains 200k+ lines of data.

DB2 is approx. 20 lines of data showing highlevel data for each scheme we run i.e. Policy Number, Scheme Name & Inception Date.

I need to produce data based upon Scheme Inception Dates which are not shown in DB1.

So I would like to run a query that extracts individual lines of data from DB1 based upon the Scheme Name I specify, but also showing a Scheme Inception Date (contained in DB2) against each line based upon the Scheme Name.

Thanks